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 votes310 views1 answer
Install sqlite npm
SQL
0 vote385 views1 answer
Sql to excel pgadmin
SQL
3 votes332 views1 answer
Force using index oracle
SQL
11 votes347 views2 answers
You are using safe update mode
SQL
0 vote343 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote369 views1 answer
Doesn't have default value mysql
SQL
0 vote391 views1 answer
Mysl like insert a variable
SQL
0 vote327 views1 answer
Mysql count with two joins
SQL
1 vote325 views1 answer
Check if mysql is installed
SQL
8 votes342 views2 answers
Sqlsrv default port
SQL