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

50 votes266 views6 answers
Sql duplicate rows
SQL
33 votes185 views2 answers
Postgres how to add field created at
SQL
3 votes176 views1 answer
Sql select all
SQL
-1 vote194 views1 answer
Condition in orderby mysql
SQL
1 vote197 views1 answer
Adding a default constraint to an existing column in sql
SQL
3 votes186 views2 answers
Postgres inner join vs join
SQL
0 vote195 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote202 views1 answer
Postgresql delete multiple rows
SQL
2 votes195 views2 answers
Postgres trigger insert into another table
SQL
0 vote230 views2 answers
Mysql show foreign keys
SQL