oracle list subpartitions

Solutions on MaxInterview for oracle list subpartitions by the best coders in the world

showing results for - "oracle list subpartitions"
Romina
03 Apr 2018
1-- Partitions of a table
2SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_COUNT, 
3       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
4FROM DBA_TAB_PARTITIONS
5WHERE TABLE_OWNER = 'MY_OWNER'
6  AND TABLE_NAME = 'MY_TABLE';
7-- Subpartitions of a table
8SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, 
9       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
10FROM DBA_TAB_SUBPARTITIONS
11WHERE TABLE_OWNER = 'MY_OWNER'
12  AND TABLE_NAME = 'MY_TABLE';