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 votes141 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
1 vote146 views1 answer
Increase existing date in sql oracle
SQL
0 vote145 views2 answers
Find lowest number in sql
SQL
0 vote137 views1 answer
Drop all procedures sql server
SQL
0 vote154 views1 answer
Trigger stock phpmyadmin
SQL
2 votes128 views2 answers
Mysql user access to database
SQL
3 votes160 views3 answers
Start postgresql ubuntu
SQL
2 votes144 views4 answers
Sql query interview questions
SQL
9 votes137 views5 answers
Sql limit
SQL
0 vote166 views2 answers
Mysql where in maintain order group_concat
SQL