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

1 vote255 views1 answer
Encrypt password postgresql
SQL
0 vote197 views1 answer
Mysql beautifier terminla
SQL
10 votes200 views5 answers
Between keyword in sql
SQL
3 votes204 views3 answers
Mysql select table names
SQL
0 vote195 views1 answer
Create a PostgreSQL user django on mac
SQL
0 vote265 views1 answer
Get initials name in sql
SQL
3 votes204 views3 answers
Raw select laravel
SQL
1 vote219 views1 answer
Sql group by sum with condition
SQL
0 vote201 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
5 votes217 views1 answer
Oracle list functions
SQL