amar on web

Various types of segments

How many types of segments are there?
The various types of segments in Oracle 7.3.4 +:

  1. data segment or table segment
  2. index segment
  3. temporary segement
  4. rollback segment
  5. bootstrap segment
  6. cluster segment    

Oracle 8+ has introduced more :
  1. table partition
  2. index partition
  3. nested table
  4. lobindex
  5. lobsegment
  6. deferred rollback etc.    

Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was created on 16-dec-2001 and last updated on 16-dec-2001.
please forward all queries to amar_padhi@fastmail.fm