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 vote255 views1 answer
Java sql timestamp now
SQL
0 vote264 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote218 views2 answers
Check mysql timezone
SQL
2 votes193 views1 answer
Latest record in sql
SQL
0 vote241 views1 answer
Consulta alias con inner join
SQL
4 votes263 views4 answers
Mysql get date from datetime
SQL
0 vote218 views1 answer
Postgre admin slow
SQL
0 vote279 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote239 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote229 views1 answer
Create sql table from script inline primary key constraint
SQL