during local system copy ORA-01652: unable to extend temp segment by 128 in tablespace

[Former Member]

Hello

During during local system copy  get ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP(I can see this in system log)

I encountered this during test phase.test client copy finished with status"Ended with errors"

in log display I can see :

RROR: Read error in client: 300 table CE11000

AB_COPY_2 -> FUNCTION DB_SETGET: SY-SUBRC =  2

tart: Recopy errors 21.09.2012 09:25:11

RROR: Read error in client: 300 table CE11000

AB_COPY_2 -> FUNCTION DB_SETGET: SY-SUBRC =  2

I increased PSAPTEMP with a data file by 20000MB ( CE11000 has 9GB in size ).

For productive client copy I have only weekend (so it has to run smoothly). I am affraid if the satus is "Ended with errors" what do I have to do?

I would not like to deletenewly created client increase again psaptemp and start clientcopy(I do not have time)

Kr

Jan

[Former Member · Accepted solution]

Hi Jan,

Did you create a datafile or a tempfile for PSAPTEMP. You need to create tempfile and not datafile which would be useless.

Regards.

Ruchit.

[Former Member]

That command can be used to add datafile:

alter tablespace PSAPTEMP add tempfile '/oracle/SID/sapdata1/temp_2/temp.data2' size 10240M autoextend on next 1024M maxsize 20480M;

Regards.

Serhat