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
Trim sql oracle
SQL
0 vote200 views1 answer
Select nth row in mysql
SQL
2 votes174 views2 answers
How to get capital letter first in sql
SQL
1 vote214 views1 answer
Postgresql round double precision
SQL
0 vote186 views1 answer
Authentication in sql server
SQL
7 votes216 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
2 votes198 views1 answer
Metasploit start postgresql
SQL
0 vote294 views1 answer
SQL query to verify the size of the table
SQL
0 vote206 views1 answer
Sql select random procentage from rows
SQL
0 vote189 views1 answer
Différence entre deux dates sql oracle
SQL