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 vote290 views1 answer
Mysql match in serialized data
SQL
0 vote275 views1 answer
Get who is hired in specific month in sql
SQL
0 vote288 views1 answer
Run mssql server terminal
SQL
5 votes297 views5 answers
Find max number in sql
SQL
4 votes296 views6 answers
Second max salary in sql
SQL
1 vote265 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
2 votes229 views1 answer
Sql group by different columns
SQL
2 votes273 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote312 views1 answer
How to add mysql to path on termin after installation
SQL
13 votes298 views2 answers
Get tables in database sql
SQL