No question at this time
DBA Top 10
1 M. Cadot 6600
2 B. Vroman 3400
3 J. PĂ©ran 2200
4 A. Kavsek 1400
5 P. Tsongayinwe 900
6 P. Wisse 600
7 T. Boles 400
7 D. Walgude 400
7 D. Johnson 400
10 J. Alcroft 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48675
Total active users1329
Act. users last 24h2
Act. users last hour0
Registered user hits last week28
Registered user hits last month451
Go up

impdp errors
Next thread: McOptions
Prev thread: Oracle RAC: Patch question

Message Score Author Date
Hi Team I am trying to import a data pump on 1...... Phuti Tsongayinwe Jan 28, 2022, 13:32
Hello, Please paste your impdp commands. Than...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts bob b Jan 28, 2022, 16:40
Hi Bob Below please find the commands: impdp...... Phuti Tsongayinwe Jan 31, 2022, 12:02
could you please share expdp command ? any error w...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts dattatraya walgude Feb 03, 2022, 11:52
Thanks, Dattatraya There are no errors during t...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Phuti Tsongayinwe Feb 03, 2022, 12:14
Ok, please update after SR solution.... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts dattatraya walgude Feb 03, 2022, 12:20
Hi Team As an update, we had to exclude some of...... Phuti Tsongayinwe May 06, 2022, 08:27

Follow up by mail Click here


Subject: impdp errors
Author: Phuti Tsongayinwe, South Africa
Date: Jan 28, 2022, 13:32, 154 days ago
Os info: solaris 11
Oracle info: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - Version 19.12.0.0.0
Error info: Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11302
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 11677
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 2064
ORA-21780: Maximum number of object durations exceeded.
Message: Hi Team

I am trying to import a data pump on 19c database but I keep on getting errors below.

First I have schema exported a dump as

I tried the dump file from another db that failed then I tried dump that I have exported from the same db that failed as well.

Please help...

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

Subject: Re: impdp errors
Author: bob b, United States
Date: Jan 28, 2022, 16:40, 154 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Hello,
Please paste your impdp commands.

Thanks,
Bob
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: impdp errors
Author: Phuti Tsongayinwe, South Africa
Date: Jan 31, 2022, 12:02, 151 days ago
Message: Hi Bob

Below please find the commands:

impdp system@dbpdb1 dumpfile=pdb_prod_exp_20220124_%U.dmp directory=directory_name parallel=4 logfile=pdb_test_imp.log

NB I have tried it without parallel=4 as well.

Thanks for the reply...
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: impdp errors
Author: dattatraya walgude, India
Date: Feb 03, 2022, 11:52, 148 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: could you please share expdp command ? any error while expdp ?
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: impdp errors
Author: Phuti Tsongayinwe, South Africa
Date: Feb 03, 2022, 12:14, 148 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Thanks, Dattatraya

There are no errors during the expdp.

I have logged an SR with Oracle, I will update the forum as soon as I get the update.

Thanks for the reply.

Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: impdp errors
Author: dattatraya walgude, India
Date: Feb 03, 2022, 12:20, 148 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Ok, please update after SR solution.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: impdp errors
Author: Phuti Tsongayinwe, South Africa
Date: May 06, 2022, 08:27, 56 days ago
Message: Hi Team

As an update, we had to exclude some of the objects and then recreate them manually.

These were the application tables and the ref_constraints.

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here