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 vote182 views1 answer
Sql combine results from two tables
SQL
3 votes179 views2 answers
Postgres inner join vs join
SQL
0 vote176 views1 answer
Dns slave zone convert
SQL
0 vote173 views1 answer
Mysql remove tabs from string
SQL
1 vote187 views5 answers
What is in operator in sql
SQL
0 vote196 views1 answer
How to delete python anywhere mysql database
SQL
0 vote183 views1 answer
Connecting mySQL to STS
SQL
1 vote191 views3 answers
Sql union
SQL
0 vote171 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote170 views1 answer
Mysql workbench download for iinux mint 19.3
SQL