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';