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

13 votes316 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote351 views2 answers
Oracle select
SQL
1 vote341 views1 answer
Postgresql last element of array
SQL
2 votes327 views1 answer
Insert from table tsql
SQL
6 votes402 views3 answers
Check if string contains substring sql
SQL
1 vote335 views1 answer
Mysql history command
SQL
1 vote345 views1 answer
Create index concurrently postgres
SQL
0 vote385 views1 answer
Postgres meta command to show all rows in table
SQL
22 votes417 views1 answer
Mysql workbench
SQL
14 votes352 views6 answers
Auto_increment mysql
SQL