ORA-1652

[Former Member]

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.

[debasissahoo]

Hi Krishna,

ORA-01652: unable to extend temp segment by 128 in tablespace PSAPTEMP
 We have turned the auto extend on for the tablespace 'PSAPTEMP'. Still no use.

Even if you put the auto extend ON, it has a max size value.. the export still requires more PSAPTEMP, if you've more space at OS level, you should increase the max size of PSAPTEMP so that it can grow more.

Regards,

Debasis.

[JPReyes]

Yes, for some reason PSAPTEMP cannot be extended....as you said AUTOEXTEND was switched on then most likely you have runned out of space at OS level, check the File system.

Regards

Juan