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 vote112 views1 answer
Can we rollback data that are deleted using DELETE
SQL
2 votes104 views1 answer
How to find constraints on a table in oracle
SQL
0 vote94 views1 answer
Run mssql server terminal
SQL
2 votes113 views1 answer
Create delete procedure mysql
SQL
0 vote113 views1 answer
Mysql coonect sample code
SQL
0 vote108 views2 answers
T sql null or empty string
SQL
19 votes57 views1 answer
Sqrt(-1)
SQL
0 vote98 views1 answer
Add colum date in sql
SQL
1 vote99 views1 answer
T-sql find object by name
SQL
0 vote104 views1 answer
Raiserror with nowait
SQL