Home » RDBMS Server » Server Administration » 10g Export error
10g Export error [message #212094] Wed, 03 January 2007 15:20 Go to next message
Rustican
Messages: 51
Registered: July 2006
Member
I'm trying to generate an export from my database and the job begins to run. I'm monitoring it through the Enterprise Manager and it's taking a long time.

I'm checking the generated dump file and it's no longer getting larger. I checked the EXPDAT.LOG file and found the following errors.

Any help would be great. Thanks!


Job "FLEET_MOD"."TEST9" stopped by user request at 15:37:23
Starting "FLEET_MOD"."TEST9":
Job TEST9 has been reopened at Wednesday, 03 January, 2007 15:37
Restarting "FLEET_MOD"."TEST9":
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-39171: Job is experiencing a resumable wait.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP...
Re: 10g Export error [message #212095 is a reply to message #212094] Wed, 03 January 2007 15:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
You are running out of temp space.
Extend the temporary tablespace or add another tempfile.
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/tspaces.htm#sthref1188
The error message is related to the resumable waits.
here is a similar example and know how on this (apart from documentation).
http://www.oracle.com/technology/pub/notes/technote_pump_restart.html
Re: 10g Export error [message #212330 is a reply to message #212095] Thu, 04 January 2007 14:11 Go to previous messageGo to next message
Rustican
Messages: 51
Registered: July 2006
Member
I made the changes to increase the table space but now when i submit the export job in the Enterprise Manager i'm getting the following errors.

Errors: ORA-31626: job does not exist
ORA-31638: cannot attach to job TEST11 for user FLEET_MOD
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 389
ORA-39077: unable to subscribe agent KUPC$A_1_20070104150956 to queue "KUPC$S_1_20070104150954"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 248
ORA-00604: error occurred at recursive SQL level 2
ORA-01654: unable to extend index SYS.I_OBJ1 by 128 in tablespace SYSTEM Exception :
ORA-31626: job does not exist ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 911
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4356
ORA-06512: at line 2

Anyone have any ideas?
Re: 10g Export error [message #212333 is a reply to message #212330] Thu, 04 January 2007 14:33 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
***somewhere*** you are running out of space.
Either withing database (check all tablespaces)
or
The external directory you allocated for the data pump.
If nothing works, increase UNDO tablespace, re-run catdp.sql.
And, i would just ignore Enterprise manager and get into simple command line utilities.
If it would not work still, raise a TAR.
regards~
Previous Topic: how to find no: of extents reached in a segment?
Next Topic: what does quiesce do ? how its different from restricted session ?
Goto Forum:
  


Current Time: Wed Dec 07 06:59:51 CST 2016

Total time taken to generate the page: 0.11013 seconds