Skip to Content
0
Former Member
Apr 23, 2009 at 05:56 PM

ORA-1652

174 Views

Hi,

We are running SAP on ECC 5.0 , Oracle 10.2 and windows 2003 x-64 bit. We have tried to export the production system and getting failed several times. The log is as follows.

-


DbSl Trace: ORA-1652 occurred when executing SQL statement (parse error offset=754)

(EXP) ERROR: DbSlExeRead failed

rc = 99, table "COEP"

(SQL error 1652)

error message returned by DbSl:

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

(DB) INFO: disconnected from DB

-


We had run the DB verify and corrected the corrupted datablocks through re-org. The re-org went sucess fully. Again we had run the export and got failed at the same place. This happend several times. We have turned the auto extend on for the tablespace 'PSAPTEMP'. Still no use. Appreciate your help on this.

Thanks,

Krishna.