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 vote310 views1 answer
Mysql delete from where like
SQL
5 votes330 views2 answers
Postgre insert select
SQL
0 vote314 views1 answer
Why mysql is used?
SQL
1 vote307 views1 answer
Delete mysql from mac
SQL
1 vote330 views1 answer
Change old domain to new domain name wordpress
SQL
0 vote332 views1 answer
Oracle execute package dblink
SQL
3 votes329 views2 answers
Oracle drop column
SQL
2 votes332 views1 answer
Codeigniter print last sql query
SQL
0 vote336 views1 answer
How to make full text search dynamic in mysql
SQL
5 votes378 views3 answers
Sql limit offset
SQL