select distinct segment_type
from dba_segments
order by segment_type
系统返回:
SEGMENT_TYPE
1
CLUSTER
2
INDEX
3
INDEX PARTITION
4
LOB PARTITION
5
LOBINDEX
6
LOBSEGMENT
7
NESTED TABLE
8
ROLLBACK
9
TABLE
10
TABLE PARTITION
11
TYPE2 UNDO