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 vote104 views1 answer
Materialized view redshift
SQL
0 vote107 views1 answer
R2dbc-postgresqldriver dependency
SQL
1 vote124 views1 answer
Postgresql update auto_increment value
SQL
0 vote125 views1 answer
Oracle table free space
SQL
0 vote166 views1 answer
Selecting specific day in colum sql
SQL
2 votes118 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote131 views2 answers
What is rownum in oracle
SQL
0 vote111 views1 answer
Where case insensitive like mysql
SQL
0 vote154 views1 answer
Sql count matching group by
SQL
0 vote127 views1 answer
How to alter length character varying postgres
SQL