Oracle list subpartitions

-- Partitions of a table
SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_COUNT, 
       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
FROM DBA_TAB_PARTITIONS
WHERE TABLE_OWNER = 'MY_OWNER'
  AND TABLE_NAME = 'MY_TABLE';
-- Subpartitions of a table
SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, 
       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
FROM DBA_TAB_SUBPARTITIONS
WHERE TABLE_OWNER = 'MY_OWNER'
  AND TABLE_NAME = 'MY_TABLE';

Similar codes

2 votes129 views1 answer
Mysql change data type of column
SQL
3 votes126 views1 answer
Sql insert inserted id
SQL
1 vote118 views3 answers
Sql union
SQL
8 votes122 views1 answer
Declare table variable sql server
SQL
2 votes106 views4 answers
Duplicate record mysql
SQL
0 vote162 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote119 views1 answer
How to select only a certain date sql
SQL
4 votes104 views2 answers
Sql vs mysql
SQL
0 vote129 views1 answer
Create table like sql
SQL
9 votes127 views3 answers
Mysql show table column full description
SQL