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 vote321 views1 answer
Joins vs includes
SQL
0 vote331 views1 answer
Window function to forward fill
SQL
0 vote345 views1 answer
Sql order by except one row
SQL
0 vote351 views2 answers
Sql query inner join 3 tables
SQL
12 votes325 views2 answers
Delete entries in postgresql
SQL
0 vote338 views1 answer
Ajax error exception handeling
SQL
0 vote330 views1 answer
Start and stop mysql
SQL
0 vote301 views1 answer
Store query result in variable sql
SQL
1 vote326 views1 answer
Add constraint sql
SQL
6 votes337 views1 answer
T-sql test if table exists
SQL