| 10g Export error [message #212094] |
Wed, 03 January 2007 15:20  |
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 #212330 is a reply to message #212095] |
Thu, 04 January 2007 14:11  |
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 |
 |
Mahesh Rajendran
Messages: 10707
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~
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
