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 vote311 views1 answer
How to add session data into mysql database from button
SQL
0 vote255 views2 answers
Influxdb delete measurement based on date
SQL
0 vote284 views1 answer
Porcentaje sql
SQL
0 vote296 views1 answer
How to find username and password in oracle 18c
SQL
4 votes302 views1 answer
Mysql ip address data type
SQL
1 vote299 views1 answer
Use of now() in mysql
SQL
0 vote301 views2 answers
Cambiar nombre tabla mysql
SQL
1 vote290 views2 answers
Create a unqie constraint mysql
SQL
5 votes285 views2 answers
Mysql drop table cascade
SQL
0 vote320 views1 answer
Capabilities of sql select statements
SQL