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 vote174 views2 answers
How to see table associated with a schema in sql
SQL
1 vote157 views1 answer
Oracle split string
SQL
3 votes109 views1 answer
If 0 return null else return query mysql
SQL
2 votes189 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote180 views1 answer
Varchar format not case sensitive sql
SQL
5 votes151 views2 answers
Copy data from one database to another
SQL
15 votes311 views2 answers
Sql order by alphabetical
SQL
0 vote161 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote167 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
0 vote119 views0 answer
SQL