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 vote138 views1 answer
Price-colour
SQL
1 vote197 views1 answer
SQL server query column yes or no
SQL
0 vote205 views2 answers
Fanyi
SQL
0 vote142 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote451 views1 answer
How to connect .sql data set to powerbi
SQL
3 votes146 views3 answers
Stop mysql ubuntu
SQL
9 votes154 views4 answers
Last mysql
SQL
0 vote174 views1 answer
Inner join distinct
SQL
1 vote135 views1 answer
Alter table column size oracle
SQL
2 votes126 views2 answers
How to get capital letter first in sql
SQL