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

5 votes260 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote198 views1 answer
Dual in db2
SQL
4 votes167 views3 answers
Mysql varchar length
SQL
1 vote136 views1 answer
Mysql collation
SQL
17 votes195 views3 answers
Postgresql version command
SQL
2 votes269 views1 answer
How to select from mssql
SQL
0 vote208 views1 answer
Oracle date summer time
SQL
18 votes210 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote180 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote289 views1 answer
Jpa generationtype sequence mysql
SQL