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 vote145 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
2 votes141 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote161 views1 answer
Mysql wsrep ls
SQL
7 votes139 views4 answers
How to reset the identity column in sql server
SQL
0 vote120 views1 answer
Lister les index d'une table oracle
SQL
1 vote140 views3 answers
Epoch to datetime
SQL
4 votes147 views1 answer
Sql data types
SQL
8 votes135 views1 answer
Sql limit results returned
SQL
1 vote152 views1 answer
Sql select max value from multiple rows
SQL
5 votes132 views5 answers
Sqlite install python
SQL