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

1 vote203 views1 answer
Mysql show table character set
SQL
3 votes185 views1 answer
Sql timestamp to date
SQL
2 votes297 views1 answer
Flask sqlalchemy boolean field
SQL
1 vote184 views1 answer
Launch sql script from docker in mysql
SQL
32 votes203 views6 answers
Insert into values select
SQL
58 votes565 views6 answers
Create new user in postgres
SQL
0 vote203 views1 answer
How to save data in database in mysql node
SQL
13 votes200 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote207 views1 answer
Closure in sql
SQL
0 vote194 views1 answer
Check sql database table lock
SQL