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 vote283 views1 answer
Sql not equal multiple columns
SQL
0 vote305 views1 answer
Mysql grant all on all databases
SQL
24 votes296 views6 answers
Alter table name sql
SQL
0 vote301 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
62 votes349 views8 answers
Mysql add column
SQL
1 vote271 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
1 vote302 views1 answer
Mysql last year
SQL
3 votes280 views1 answer
Uppercase and lowercase in sql
SQL
0 vote253 views1 answer
Mysql events not work
SQL
0 vote264 views1 answer
Sub query in linq
SQL