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.