Types of segments?
Posted by silpa on Sep 17 2007
data segment
each non cluster/cluster table has a data segment.Tables data is stored in the extent of its data segment
index segment
each index has index segment to store its data
rollback segment
db contains one or more rollback segments to temporarily store undo information
temporary segment
temporary segments are created when SQL statements need temporary work area to complete execution.
Leave a Comment