No question at this time
DBA Top 10
1 M. Cadot 7400
2 B. Vroman 1700
3 P. Wisse 1300
4 P. Tsongayinwe 1200
5 J. PĂ©ran 800
6 J. Schnackenberg 400
7 J. Alcroft 200
7 D. Walgude 200
7 B. M 200
10 A. Hudspith 100
10 L. Ywema 100
10 D. Johnson 100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48726
Total active users1323
Act. users last 24h0
Act. users last hour0
Registered user hits last week35
Registered user hits last month263
Go up

expdp fails
Next thread: How to Restore RAC RMAN backup to stand alone
Prev thread: convert table in partition

Message Score Author Date
expdp userid=system/system01 directory=purge tran...... Oracle DBA Aug 08, 2012, 16:15
Kindly check whether that mentioned job exist in d...... Mirza Hidayathullah Baig Aug 08, 2012, 17:02
HI! ORA-31626 tips Question: I just ran...... :) Denis L Aug 09, 2012, 05:19
Even if i don't specify the job_name i face the sa...... Oracle DBA Aug 09, 2012, 07:51
Answer: This ORA-31626 error may be a bug. See MOS...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts :) Denis L Aug 09, 2012, 08:36

Follow up by mail Click here


Subject: expdp fails
Author: Oracle DBA, India
Date: Aug 08, 2012, 16:15, 3881 days ago
Os info: HP UX 11.23
Oracle info: 10.2.0.5
Message: expdp userid=system/system01 directory=purge transport_tablespaces=purge dumpfile=purge_data.dmp logfile=purge_exp.log job_name=test

Export: Release 10.2.0.5.0 - 64bit Production on Wednesday, 08 August, 2012 14:12:06

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist


Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: expdp fails
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Aug 08, 2012, 17:02, 3881 days ago
Message: Kindly check whether that mentioned job exist in database
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: expdp fails
Author: :) Denis L, Ukraine
Date: Aug 09, 2012, 05:19, 3880 days ago
Message: HI!


ORA-31626 tips

Question: I just ran an import (impdp on Oracle 10g r2) and I'm getting the error "ORA-31626: Job does not exist". and a bunch of other errors:

ORA-31626: job does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist

What is the cause of the ORA-31626: Job does not exist error? I'm not scheduling and jobs!

Answer: This ORA-31626 error may be a bug. See MOSC note 549781.1 for details.

Also see DBA_DATAPUMP_JOBS Tips for finding aborted import jobs.

Here are details on the ORA-31626 error and I agree, it makes to sense to see a ORA-31626 error when running impdp:

ORA-31626: Job does not exist

Cause: An invalid reference to a job which is no longer executing, is not executing on the instance where the operation was attempted, or that does not have a valid Master Table. Refer to any following error messages for clarification.

Action: Start a new job, or attach to an existing job that has a valid Master Table
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: expdp fails
Author: Oracle DBA, India
Date: Aug 09, 2012, 07:51, 3880 days ago
Message: Even if i don't specify the job_name i face the same error
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: expdp fails
Author: :) Denis L, Ukraine
Date: Aug 09, 2012, 08:36, 3880 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Answer: This ORA-31626 error may be a bug. See MOSC note 549781.1 for details.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here