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

4 votes223 views3 answers
Sqlite show columns
SQL
0 vote223 views1 answer
Mysql date only no time
SQL
0 vote252 views1 answer
Hour and minute between two datatime sql
SQL
0 vote231 views1 answer
How to move a column to different spot mysql
SQL
0 vote269 views1 answer
Mysql streaming example
SQL
0 vote226 views1 answer
Mysqldump ignore table
SQL
0 vote239 views1 answer
Compare two tables to find unmatched records
SQL
1 vote219 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote239 views1 answer
Resullt all update knex mysql
SQL
0 vote184 views1 answer
Mysql offset from bottom
SQL