Showing posts with label ORA-01630. Show all posts
Showing posts with label ORA-01630. Show all posts

Tuesday, 17 January 2012

ORA-01630: max # extents (string) reached in temp segment in tablespace string

ORA-01630: max # extents (string) reached in temp segment in tablespace string

Cause: A temp segment tried to extend past max extents.

Action: If maxextents for the tablespace is less than the the system maximum, you can raise that. Otherwise, raise pctincrease for the tablespace