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 vote275 views1 answer
How to use db.execute
SQL
0 vote257 views1 answer
Oracle synonym procedure dblink
SQL
2 votes260 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote239 views8 answers
Convert sql query to linq online
SQL
0 vote265 views1 answer
Sql server roles and users
SQL
0 vote245 views1 answer
How to see the query of a view in mysql
SQL
5 votes285 views3 answers
Sql server utc to local
SQL
0 vote264 views1 answer
Sql show all users
SQL
0 vote252 views1 answer
Create new table pl sql
SQL
1 vote260 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL