Oracle list partitions

-- 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 = 'DSI_TAHITI'
  AND TABLE_NAME = 'COURBE';
-- 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 = 'DSI_TAHITI'
  AND TABLE_NAME = 'COURBE';

Similar codes

0 vote215 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote174 views1 answer
Mysql root permission denied lost
SQL
-1 vote182 views2 answers
Import data from excel to sql server automatically
SQL
2 votes236 views1 answer
Sql missing records from another table
SQL
6 votes178 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote170 views1 answer
Psql connections
SQL
2 votes193 views3 answers
Application.properties spring boot mysql
SQL
0 vote175 views1 answer
Oracle table free space
SQL
0 vote162 views1 answer
Pgadmin see indexes
SQL
5 votes185 views3 answers
String concatenation sql server
SQL