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 vote351 views3 answers
What is union in sql
SQL
0 vote318 views1 answer
Check index sql server
SQL
15 votes347 views5 answers
If null mysql
SQL
0 vote348 views1 answer
Get null value in sql
SQL
0 vote361 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote340 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote366 views1 answer
Psql filed name alter
SQL
0 vote347 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
4 votes369 views1 answer
Ms sql truncate table vs delete
SQL
1 vote385 views1 answer
Mysql update inner
SQL