Oracle error : ORA-01632 : Max extents reached in index

Error: ORA-01632
Text: max # extents (%s) reached in index %s.%s
—————————————————————
Cause: An index tried to extend past maxextents
Action: If maxextents is less than the system max, raise it.
Otherwise, you must recreate with larger initial, next
or pctincrease params. Continue reading

Advertisements

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