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

1 vote167 views3 answers
Sql server get week dates from week number
SQL
3 votes235 views1 answer
Oracle apex warn on unsaved changes
SQL
4 votes182 views1 answer
Adding data to table in sql python
SQL
16 votes184 views2 answers
Oracle ddl
SQL
1 vote167 views1 answer
Get table column names sql ssms
SQL
1 vote145 views1 answer
Ms sql - add one hour to time
SQL
4 votes197 views6 answers
Second max salary in sql
SQL
3 votes167 views1 answer
Postgres kill running query
SQL
44 votes291 views4 answers
Mysql alter table add column first
SQL
0 vote175 views1 answer
Create a PostgreSQL user django on mac
SQL