BR886E Checking/collecting statistics failed for table/index SAPZND.JEST

BASIS ERRORS: 

BR301E SQL error -1652 at location stats_tab_collect-3

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

BR886E Checking/collecting statistics failed for table/index SAPZND.JEST

Root Cause:  There is not enough space left on PSAPTEMP

Solution: Increase the space for the PSAPTEMP temporary tablespace

Extra Info:

Note : 191798

Tags: ORA-01652: unable to extend temp segment by 2560 in tablespace PSAPTEMP, BR301E SQL error -1652 at location stats_tab_collect-3, not enough space left on PSAPTEMP, 

0 comments

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

0 comments