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 vote115 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote196 views3 answers
Osx stop mysql service
SQL
0 vote121 views1 answer
How to output a different column name in mysql
SQL
0 vote112 views1 answer
Check if a word appears at the end sql query
SQL
0 vote136 views1 answer
Mysql group by range
SQL
1 vote116 views1 answer
Mysql server does not start mac
SQL
0 vote121 views1 answer
MySQL error code 2068
SQL
1 vote140 views1 answer
Mysql find tables with column name
SQL
0 vote117 views1 answer
Changer un mot de passe mysql
SQL
3 votes121 views2 answers
Monthname sql
SQL