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

[Former Member]

Hi Everybody;

My coleague who is an bw consultant facing given below problem in BW production server.

Error reading the data of InfoProvider ZN_IVLTD

Error when generating the sql statement.

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

I checked table space PSAPTEMP as well but its showing o% used.

Kindly help how can i resolve this problem.

Regards

Santosh

[Former Member · Accepted solution]

Hi,

You need to extend the size of a temporary segment that is used by your ODS object in tablespace PSAPTEMP.

Check SAP Note 387946 - USE OF LOCALLY MANAGED TABLESPACES FOR BW SYSTEMS

regards,

kaushal

[Former Member · Accepted solution]

Hi Santosh,

There is also this thread going on, check if anything will be useful for you.

One problem that I have noticed on UNIX systems for PSAPTEMP, refer to the this note if your OS is UNIX.

548221 - Temporary Files are created as sparse files

Regards,

Nilesh

[Former Member · Accepted solution]

Hi Nilesh,

Hint with SPARSE files was very good!

Recently I had the same problem (ORA-1652) on SLES and after I copied files with "--sparse=never" option problem was solved. Before I tried with RESIZE like this:

ALTER DATABASE TEMPFILE 'MYFILE' RESIZE 4000M;

This didn't worked. File size was changed but I could still observe ORA-1652 error.

Regards

Rafal

[Former Member · Accepted solution]

Hi Rafal,

If the problem is solved, can you please close this thread.

Regards,

Nilesh