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 views1 answer
Sql server count all tables rows
SQL
15 votes295 views7 answers
MYSQL
SQL
0 vote276 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote277 views1 answer
Check if table exists oracle
SQL
4 votes307 views2 answers
Oracle unlock account
SQL
0 vote279 views1 answer
View acl table oracle
SQL
0 vote306 views1 answer
Select sql in descending order
SQL
0 vote231 views1 answer
Mysql collation for all languages
SQL
1 vote224 views1 answer
How to run sql script
SQL
-1 vote298 views1 answer
Window functions in sql
SQL