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 vote173 views1 answer
Group by max date
SQL
0 vote136 views3 answers
Sql count condition
SQL
0 vote150 views1 answer
Postgres 11 add primary key
SQL
1 vote161 views1 answer
Oracle index partition
SQL
0 vote153 views1 answer
Test sql query
SQL
0 vote119 views1 answer
Copy data from cell to cell mysql
SQL
0 vote145 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote158 views1 answer
Postgresql on conflict pair
SQL
12 votes159 views1 answer
Psql drop column
SQL
4 votes145 views2 answers
How to delete row in sql
SQL