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

25 votes195 views5 answers
Date in mysql
SQL
0 vote195 views1 answer
Creating a simple notify in postgresql
SQL
0 vote244 views1 answer
Ora 00001 error catch plsql
SQL
0 vote186 views1 answer
Sql offfset
SQL
1 vote204 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
0 vote194 views1 answer
Sql output select
SQL
0 vote202 views1 answer
Default column value in sql same as another column laravel
SQL
12 votes179 views2 answers
Delete all nodes neo4j
SQL
0 vote180 views1 answer
Sql convert datetime to year
SQL
3 votes310 views1 answer
Ssh check mysql version
SQL