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 vote116 views1 answer
Oracle sql count occurrences of value in column
SQL
1 vote171 views1 answer
Psql client write to bash variable
SQL
1 vote126 views1 answer
Get last week data in mysql
SQL
0 vote82 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote143 views1 answer
Look at running processes redshift
SQL
1 vote123 views1 answer
Woocommerce mysql price table
SQL
1 vote133 views1 answer
DATE_SUB postgres
SQL
0 vote131 views1 answer
MySQL FIND_IN_SET()
SQL
4 votes136 views1 answer
Group by mysql and concatenate string
SQL
0 vote172 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL