Oracle DBA, How To, Error, Cause and Action

ORA-01652: unable to extend temp segment by string in tablespace string

ORA-01652: unable to extend temp segment by string in tablespace string


Cause:


Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.



Action:


Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

No comments:

Post a Comment

Thanks for your comment.