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 vote164 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
1 vote100 views1 answer
Can we drop a primary key
SQL
0 vote127 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote116 views1 answer
Display first three characters sql
SQL
1 vote113 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote78 views1 answer
Postgresql add leading zeros
SQL
8 votes128 views4 answers
Postgresql server restart
SQL
2 votes108 views2 answers
Spring import sql
SQL
0 vote116 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote370 views1 answer
Create pl/sql stored procedure
SQL