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

2 votes384 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote354 views1 answer
Commit transaction sql
SQL
0 vote368 views1 answer
Insert or update sql query
SQL
0 vote368 views1 answer
Select row with latest date mysql
SQL
0 vote366 views1 answer
Set classpath for mysql-connector.jar
SQL
-1 vote355 views1 answer
Sql set max value in column
SQL
0 vote359 views1 answer
Mariadb hours between two dates
SQL
18 votes363 views3 answers
Mysql add column with default value
SQL
0 vote378 views2 answers
Suse stop MySQL
SQL
0 vote395 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL