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 vote358 views1 answer
Python escape mysql
SQL
0 vote690 views1 answer
Create pl/sql stored procedure
SQL
3 votes405 views6 answers
DB::table('users')->get();
SQL
0 vote385 views1 answer
What is initial catalog in sql connection string
SQL
0 vote345 views1 answer
Sql server port 1434
SQL
0 vote348 views1 answer
Count characters of string mysql
SQL
1 vote359 views3 answers
Execute sp in sql server
SQL
0 vote354 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote381 views1 answer
Mysql connect bash
SQL
0 vote305 views1 answer
How to check oracle index table
SQL