I would like to know what all the different type of segments are that exist in Oracle. I know about Index segment (Each Index has an Index segment that stores all of its data). If anybody knows about this then please post the answer.
asked
What are the different types of Segments ?
It depends on the version, the Reference manual lists the possible types in the documentation for the DBA_SEGMENTS view. (Though I think this may not be complete).
The segment types listed for 10gR2 are; INDEX PARTITION, TABLE PARTITION, TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE, LOBSEGMENT and LOBINDEX
In 11gR2 the possible types of segment listed are; NESTED TABLE, TABLE, TABLE PARTITION, CLUSTER, LOBINDEX, INDEX, INDEX PARTITION, LOBSEGMENT, TABLE SUBPARTITION, INDEX SUBPARTITION, LOB PARTITION, LOB SUBPARTITION, ROLLBACK, TYPE2 UNDO, DEFERRED ROLLBACK, TEMPORARY, CACHE, SPACE HEADER, UNDEFINED
(Though I'm sure that at least SPACE HEADER has existed for ages, it's created when a dictionary managed tablespace is converted to locally managed).
