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 vote280 views3 answers
Run sql command line
SQL
1 vote262 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote214 views1 answer
Bigquery information_schema schema all columns
SQL
1 vote258 views1 answer
Find a column in all tables postgres
SQL
0 vote264 views4 answers
Mysql count table rows
SQL
0 vote260 views1 answer
Mysql 8 error on identified by
SQL
0 vote328 views2 answers
Mysql insert rows to another database
SQL
1 vote262 views1 answer
Sql first
SQL
3 votes270 views1 answer
Oracle transaction commit rollback example
SQL
0 vote253 views1 answer
What is the use of index in mysql table
SQL