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 vote132 views1 answer
Postgres division by zero
SQL
0 vote278 views5 answers
Right join
SQL
2 votes158 views1 answer
Oracle create directory
SQL
2 votes165 views1 answer
Mysql virtual column
SQL
0 vote176 views1 answer
What is between keyword used for
SQL
1 vote175 views1 answer
Mysql breakline on string
SQL
0 vote174 views1 answer
Multiple tricky query in sql server
SQL
5 votes178 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote163 views1 answer
In mysql workbench contnent not feching
SQL
4 votes163 views1 answer
Select first and last row sql
SQL