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 vote380 views1 answer
Prodection ready postgres database step by step
SQL
6 votes342 views4 answers
Sqlite drop table
SQL
1 vote367 views1 answer
Postgresql escape single quote
SQL
1 vote369 views1 answer
Random name function in mysql for nvarchar
SQL
-1 vote360 views1 answer
Mysql case when multiple conditions
SQL
11 votes354 views1 answer
Mysql text type max length
SQL
2 votes354 views2 answers
How to check data type in sql server
SQL
1 vote345 views2 answers
Mysql join two tables
SQL
0 vote360 views1 answer
Edit a field mysql terminal
SQL
-1 vote379 views1 answer
How to change the auto increment in existing table mysql
SQL