Pages

ORA-1652: unable to extend temp segment by 128 in tablespace


SAP ORACLE ERROR : ORA-1652: unable to extend temp segment by 128 in tablespace PSAPTEMP

Root 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.

Note: you should turn off autoextend for both UNDO and Temp tablespace

No comments:

Post a Comment