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 vote163 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
6 votes181 views2 answers
WHERE value IS sql
SQL
0 vote149 views2 answers
Postgresql gset
SQL
1 vote155 views1 answer
Oracle sql first day of year
SQL
0 vote159 views2 answers
Advantages of stored procedures sql
SQL
1 vote158 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote146 views1 answer
Add multiple field in table sql
SQL
1 vote179 views1 answer
Epoch time converter in snowflake
SQL
1 vote177 views2 answers
How to add amount between date in sql
SQL
6 votes191 views1 answer
Check Table Exists
SQL