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 vote153 views1 answer
Drush run sql select
SQL
8 votes156 views1 answer
Declare table variable sql server
SQL
0 vote183 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
1 vote147 views1 answer
Postgresql contains
SQL
0 vote144 views1 answer
Sql server select top 2 of each group
SQL
11 votes133 views2 answers
Having clause
SQL
22 votes250 views4 answers
Tsql rename table
SQL
0 vote134 views1 answer
Join creating duplicate columns sqllite
SQL
13 votes144 views1 answer
Views in sql
SQL
0 vote253 views1 answer
Sql server query all database objects
SQL