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 vote197 views1 answer
Sql pad left 0
SQL
5 votes186 views1 answer
Oracle find foreign key dependencies
SQL
0 vote184 views1 answer
Json_remove mysql
SQL
0 vote184 views1 answer
Mysql local password denied
SQL
1 vote189 views2 answers
Mysql select tables with name like
SQL
18 votes191 views2 answers
Sql inner join
SQL
24 votes192 views4 answers
Postgres remove database
SQL
0 vote243 views1 answer
Sql trim whitespace
SQL
10 votes207 views2 answers
What is database
SQL
7 votes195 views6 answers
Group_concat mysql
SQL