Segments in Oracle

A segment is a container for objects (such as tables, indexes….).
A segment consists of extents.
Segment types
There are 11 types of segments in Oracle 10g:

  • table
  • table partition
  • index
  • index partition
  • cluster
  • rollback
  • deferred rollback
  • temporary
  • cache
  • lobsegment
  • lobindex

Continue reading

Advertisements