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

3 votes299 views2 answers
Having in mysql
SQL
12 votes373 views6 answers
Change mysql root password
SQL
0 vote319 views1 answer
Mysql repair a table
SQL
0 vote323 views1 answer
Qt qsql check if table exist
SQL
0 vote312 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote313 views2 answers
How to get json data mysql
SQL
11 votes303 views2 answers
Import sql file laravel cmd
SQL
0 vote313 views1 answer
Database get 10 user aleatory
SQL
0 vote353 views1 answer
Sql ssrs
SQL
0 vote325 views1 answer
Mysql loop through databases and execute query
SQL