how to see all table partition in oracle

Delta Sierra answered on September 21, 2020 Popularity 7/10 Helpfulness 8/10

answer how to see all table partition in oracle

related oracle list partitioned tables

how to see all table partition in oracle

Comment

SELECT * FROM ALL_TAB_PARTITIONS;

Popularity 7/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: oracle partition sql

Link to this answer
Share Copy Link

Contributed on Sep 21 2020

Delta Sierra

0 Answers Avg Quality 2/10

Closely Related Answers

oracle list partitioned tables

Comment

-- List of partitioned tables
SELECT DISTINCT P.TABLE_OWNER, P.TABLE_NAME, count(*) AS NB_PARTITIONS, 
	SP.NB_SUBPARTITIONS
FROM DBA_TAB_PARTITIONS P
LEFT JOIN (SELECT DISTINCT TABLE_OWNER, TABLE_NAME, count(*) AS NB_SUBPARTITIONS
           FROM DBA_TAB_SUBPARTITIONS
           GROUP BY TABLE_OWNER, TABLE_NAME, PARTITION_NAME
          ) SP
ON P.TABLE_OWNER = SP.TABLE_OWNER AND P.TABLE_NAME = SP.TABLE_NAME
WHERE P.TABLE_OWNER NOT IN ('SYS', 'SYSTEM')
GROUP BY P.TABLE_OWNER, P.TABLE_NAME, SP.NB_SUBPARTITIONS
ORDER BY P.TABLE_OWNER, P.TABLE_NAME;

Popularity 8/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: oracle sql list lis

Link to this answer
Share Copy Link

Contributed on Mar 19 2021

VasteMonde

0 Answers Avg Quality 2/10

how to see all table partition in oracle

Contents

More Related Answers

how to see all table partition in oracle

Closely Related Answers

oracle list partitioned tables

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.