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

1 vote264 views1 answer
Psql lst trigger
SQL
0 vote272 views1 answer
Frename oracle
SQL
13 votes299 views3 answers
Mysqldump structure only
SQL
49 votes307 views6 answers
Alter table add column
SQL
10 votes324 views4 answers
Join multiple tables in sql
SQL
2 votes289 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
0 vote242 views1 answer
Mysql select distinct date from timestamp
SQL
8 votes296 views1 answer
Oracle search stored procedures for text
SQL
0 vote264 views1 answer
What is ssrs and ssis in sql server
SQL
7 votes246 views2 answers
N highest salary in sql
SQL