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 vote136 views1 answer
Postgresql get diff between two dates in Months
SQL
1 vote150 views3 answers
Connection string mysql
SQL
0 vote109 views1 answer
Create bakupd database sqlserver
SQL
0 vote130 views1 answer
Greater than or equal to symbol in postgres
SQL
1 vote121 views2 answers
Mysql trim whitespace
SQL
1 vote167 views2 answers
Job for mysql.service failed because the control process exited with error code. see "systemctl status mysql.service" and "journalctl -xe" for details.
SQL
0 vote136 views1 answer
Sql period overlap
SQL
0 vote140 views2 answers
Sql searching via key word
SQL
0 vote141 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote131 views1 answer
Mysql query single row
SQL