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 votes236 views1 answer
Mysql application.properties spring boot
SQL
0 vote235 views1 answer
Write sql query to show the details start from digit
SQL
1 vote238 views1 answer
Tsql find foreign key references
SQL
0 vote241 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote241 views1 answer
Sql select duplicates based on two columns
SQL
5 votes244 views1 answer
Sort order on two columns sql
SQL
-1 vote187 views3 answers
Ubuntu install mssql
SQL
0 vote197 views1 answer
Oracle list all stored procedures
SQL
0 vote233 views1 answer
Mssql view column data type
SQL
1 vote228 views1 answer
Crontab every month
SQL