Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

expdp attach job

850316Jul 14 2011 — edited Jul 14 2011
hi friends,

i am doing the expdp as follows,but i am getting errors while attach the job

please give me the solution for the following



C:\>expdp scott/tiger directory=d1 dumpfile=dept.dmp logfile=deptlog.log tables=
'EMP' job_name=expjob

Export: Release 11.1.0.7.0 - Production on Thursday, 14 July, 2011 12:00:39

Copyright 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing option
C:\>expdp scott/tiger directory=d1 dumpfile=dept.dmp logfile=deptlog.log tables=
'EMP' job_name=expjob

Export: Release 11.1.0.7.0 - Production on Thursday, 14 July, 2011 12:00:39

Copyright 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing option
Starting "SCOTT"."EXPJOB": scott/******** directory=d1 dumpfile=dept.dmp logfil
e=deptlog.log tables='EMP' job_name=expjob
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Export> status

Job: EXPJOB
Operation: EXPORT
Mode: TABLE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: E:\EXTERNAL\DEPT.DMP
bytes written: 4,096

Worker 1 Status:
Process Name: DW01
State: EXECUTING

Export> exit_client
UDE-31626: operation generated ORACLE error 31626
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 902
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2906
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4129
ORA-06512: at line 1


C:\>expdp scott/tiger attach=EXPJOB

Export: Release 11.1.0.7.0 - Production on Thursday, 14 July, 2011 12:02:45

Copyright 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT", line 386
ORA-31638: cannot attach to job EXPJOB for user SCOTT
ORA-31632: master table "SCOTT.EXPJOB" not found, invalid, or inaccessible
ORA-00942: table or view does not exist
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2011
Added on Jul 14 2011
#general-database-discussions
1 comment
2,250 views