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

0 vote282 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
2 votes306 views2 answers
Mysql does sentence contain word
SQL
0 vote281 views1 answer
Android sqlite add column if not exists
SQL
4 votes269 views1 answer
Oracle user tables
SQL
-1 vote308 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote269 views1 answer
Porcentaje sql
SQL
1 vote308 views1 answer
Drop primary key oracle
SQL
4 votes264 views1 answer
To date oracle with time
SQL
3 votes296 views1 answer
Sql case update
SQL
1 vote285 views1 answer
Snowflake rename column name
SQL