Go up

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......		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......		dattatraya walgude	Feb 03, 2022, 11:52
Thanks, Dattatraya There are no errors during t......		Phuti Tsongayinwe	Feb 03, 2022, 12:14
Ok, please update after SR solution....		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, 486 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, 486 days ago
Score:
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, 483 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, 480 days ago
Score:
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, 480 days ago
Score:
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, 480 days ago
Score:
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, 388 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