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

22 votes225 views3 answers
Year format in date mysql
SQL
20 votes186 views2 answers
Mysql bigint max value
SQL
-2 votes202 views1 answer
Mysql see users and passwords
SQL
0 vote191 views1 answer
Oracle job class
SQL
-1 vote224 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote226 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote161 views1 answer
Sqlalchemy filter relationship
SQL
15 votes193 views2 answers
How to drop database name in postgresql
SQL
22 votes263 views4 answers
Mysql format date
SQL
0 vote197 views1 answer
Sql row number in result set
SQL