Types Of Segments in Oracle
SQL> SELECT distinct segment_type from dba_Segments;
SEGMENT_TYPE
------------------
INDEX
CLUSTER
TABLE PARTITION
LOBINDEX
TABLE SUBPARTITION
SYSTEM STATISTICS
LOBSEGMENT
INDEX PARTITION
ROLLBACK
TABLE
LOB PARTITION
SEGMENT_TYPE
------------------
NESTED TABLE
TYPE2 UNDO
13 rows selected.