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 vote115 views1 answer
To_date sql
SQL
0 vote103 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote96 views1 answer
Sql select maximum column with other columns returned
SQL
1 vote106 views1 answer
Sql sort column by date
SQL
0 vote136 views1 answer
Mysql 3 months ago
SQL
23 votes108 views4 answers
How to show all users in mysql
SQL
0 vote102 views1 answer
Hive batch drop table
SQL
10 votes89 views1 answer
Oracle dependency
SQL
8 votes126 views4 answers
Reset SQL auto increment
SQL
1 vote100 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL