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
Share this article :

Post a Comment

 
Copyright © 2011. SAP BASIS ANSWERS | SAP BASIS ADMIN BLOG - All Rights Reserved
T C P M
Proudly powered by Blogger