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 vote357 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote357 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote337 views1 answer
Create tables from xsd to sql server database c#
SQL
3 votes337 views2 answers
Df to sql pandas sql achemy
SQL
0 vote303 views2 answers
Sql update from two different database
SQL
8 votes371 views2 answers
How to fetch data from database without last column
SQL
0 vote322 views1 answer
Json_remove mysql
SQL
41 votes434 views6 answers
Alter table add column in SQL Server
SQL
0 vote344 views1 answer
Install mysql for fedora 34
SQL
0 vote353 views1 answer
Oracle sql copy table without data
SQL