32 bit EHp1 system export error on Oracle 10.2.0.2 & windows

[Former Member]

Hi All,

I am performing export of solman EHp1 system base on Oracle 10.2.0.2 & windows 2003(32 bit) bot database & OS).

Database size is 100 gig.during export it stope at error.

I checked sapinst.log which shows below error

-

---

INFO[E] 2010-09-16 21:03:20.328

CJS-30022 Program 'Migration Monitor' exits with error code 103. For details see log file(s) export_monitor.java.log, export_monitor.log.

ERROR 2010-09-16 21:03:20.343

FCO-00011 The step runMigrationMonitor with step key |NW_Export|ind|ind|ind|ind|0|0|NW_ABAP_Export_Dialog|ind|ind|ind|ind|4|0|NW_ABAP_Export|ind|ind|ind|ind|0|0|runMigrationMonitor was executed with status ERROR.

-

---

Then I checked export_monitor.java.log

-

---

java version "1.4.2_13"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_13-b06)

Java HotSpot(TM) Client VM (build 1.4.2_13-b06, mixed mode)

Export Monitor jobs: running 0, waiting 18, completed 1, failed 0, total 19.

Export Monitor jobs: running 1, waiting 17, completed 1, failed 0, total 19.

Export Monitor jobs: running 2, waiting 16, completed 1, failed 0, total 19.

Export Monitor jobs: running 3, waiting 15, completed 1, failed 0, total 19.

Export Monitor jobs: running 3, waiting 14, completed 2, failed 0, total 19.

Unloading of 'SAPAPPL1' export package: ERROR

Export Monitor jobs: running 2, waiting 14, completed 2, failed 1, total 19.

-

---

Then I again chked SAPAPPL1 log file

-

---

DbSl Trace: Error 1652 in stmt_fetch() from oci_execute_stmt(), orpc=0

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

(EXP) ERROR: DbSlExeRead failed

rc = 99, table "ALALERTDB"

(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

E:\usr\sap\X11\SYS\exe\nuc\NTI386\R3load.exe: job finished with 1 error(s)

-

---

Regards

Sarth

[Former Member · Accepted solution]

Hi,

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

Try to extend the temp tablespace (PSAPTEMP) using BRTools and then continue the export process.

Hope this will resolve ur isse.

Regards,

Varadharajan M

[Former Member · Accepted solution]

Thnaks Varadhu,

My Databse size is 100GB.after export what will be export file size.I have 20 GB of free space I have.

Not sure if it would be sufficient.

Regards

Sarth

[former_member709110 · Accepted solution]

Export dump is generally around less than 20% of the actual data, but again there is no thumb rule as size is also influenced by the kind of table and data you have (the data type) .

Regards,

Neel

[Former Member · Accepted solution]

Hi Sarth,

The DB export won't require more space. I guess 20 GB is more than enough for this.

Mark the thread as answered if ur issue is resolved and open a new thread for other concerns/queries.

Regards,

Varadharajan M

[Former Member · Accepted solution]

Thanks Varadhu for your help with this.