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 vote173 views1 answer
Show table details postgresql
SQL
2 votes178 views2 answers
Mysql count rows returned
SQL
2 votes163 views1 answer
Sqlite show table indexes
SQL
0 vote163 views1 answer
Insert or update sql query
SQL
0 vote209 views1 answer
Mysql select row with min date
SQL
0 vote189 views3 answers
Join
SQL
0 vote157 views3 answers
Sql count condition
SQL
0 vote168 views1 answer
What does leave do in mysql
SQL
3 votes173 views1 answer
Laravel paginate raw sql
SQL
3 votes163 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL