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 vote367 views1 answer
Postrgres trunc
SQL
7 votes402 views3 answers
Sql server check if temp table exists
SQL
1 vote343 views1 answer
Postgres select as csv
SQL
5 votes346 views1 answer
Postgresql functions
SQL
4 votes326 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote361 views1 answer
Oracle webcenter content search enginer
SQL
9 votes376 views3 answers
Postgres make sql dump
SQL
0 vote330 views1 answer
Back up stored procedures mysql
SQL
2 votes331 views2 answers
Exec procedure pl sql
SQL
0 vote334 views1 answer
Oracle sql winter time change
SQL