Oracle DBA, How To, Error, Cause and Action

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

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