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

12 votes216 views6 answers
Select distinct
SQL
0 vote222 views3 answers
Insert query in ci
SQL
1 vote214 views3 answers
Union SQL
SQL
0 vote326 views1 answer
Postgresql powershell query
SQL
6 votes253 views2 answers
Install psql mac
SQL
0 vote209 views1 answer
Format the money fied with comma in international system using sql
SQL
7 votes195 views1 answer
Mysql load data infile csv
SQL
7 votes209 views1 answer
Safe mode mysql
SQL
0 vote262 views1 answer
Plpgsql create function
SQL
0 vote217 views2 answers
Mysql on update current_timestamp
SQL