oracle list partitions

1-- Partitions of a table
2SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_COUNT, 
3       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
4FROM DBA_TAB_PARTITIONS
5WHERE TABLE_OWNER = 'DSI_TAHITI'
6  AND TABLE_NAME = 'COURBE';
7-- Subpartitions of a table
8SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, 
9       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
10FROM DBA_TAB_SUBPARTITIONS
11WHERE TABLE_OWNER = 'DSI_TAHITI'
12  AND TABLE_NAME = 'COURBE';