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

2 votes331 views1 answer
Sql update from different table
SQL
0 vote308 views2 answers
Php convert dbf to mysql
SQL
3 votes316 views3 answers
Into in sql
SQL
5 votes344 views1 answer
Sql add column after another
SQL
3 votes312 views3 answers
Mysqldump: couldn
SQL
0 vote328 views1 answer
Sql add calculated column
SQL
20 votes318 views4 answers
Reset auto increment in MySQL
SQL
0 vote310 views1 answer
Mysql regex exact match
SQL
1 vote309 views1 answer
GROUP BY clause; this is incompati
SQL
0 vote323 views1 answer
Mariadb hours between two dates
SQL