Issue:
When tried to Import a table from one Oracle database to another using IMPDP utility,encountered the error ORA-31604: invalid transform NAME parameter “MODIFY” for object type PROCACT_INSTANCE in function ADD_TRANSFORM
Impdp logfile has the below error:
Starting “<LOGIN_SCHEMA>”.”SYS_IMPORT_FULL_10″: <LOGIN>/******** parfile=<PARFILE_NAME>.par logfile=<LOG_NAME>.log dumpfile=<DUMPFILE_NAME>.dmp parallel=1
Processing object type TABLE_EXPORT/TABLE/PROCACT_INSTANCE
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_MD_TRANSFORMS []
ORA-31604: invalid transform NAME parameter “MODIFY” for object type PROCACT_INSTANCE in function ADD_TRANSFORM
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86
ORA-06512: at “SYS.KUPW$WORKER”, line 8996
Cause: This is a bug in Oracle Database versio 11g, fixed in Oracle Database version 12c
Solution:
As a workaround, implement any of the below solutions:
1. Use an additional parameter that is exclude=PROCACT_INSTANCE during impdp
2. Redo the export with exclude=PROCACT_INSTANCE and perform import using new dumpfiles.
The use of the exclude=PROCACT_SYSTEM will exclude the resource manager objects such as resource plans and groups. We need to re-create resource plans and groups after impdp is successfully completed.
I’m not sure the place you are getting your information, however great topic.
I needs to spend a while finding out much more or understanding more.
Thanks for wonderful information I was looking for this information for my mission.
Feel free to visit my blog :: nordvpn coupons inspiresensation, tinyurl.com,
Just wish to say your article is as astonishing.
The clarity in your post is just spectacular and i can assume you’re an expert
on this subject. Fine with your permission allow me to grab your RSS feed
to keep updated with forthcoming post. Thanks a million and please continue the enjoyable work.
Feel free to surf to my web blog; nordvpn coupons inspiresensation
I’m now not sure the place you are getting your information, however good topic.
I needs to spend some time finding out more or figuring out more.
Thank you for magnificent info I used to be looking for this information for my mission.
Look into my site: Nordvpn coupons inspiresensation (t.co)
nordvpn coupons inspiresensation 350fairfax
Excellent post. I was checking constantly this weblog and
I am inspired! Extremely helpful information specially the ultimate part 🙂 I
maintain such information much. I used to be seeking this certain information for a
very lengthy time. Thank you and best of luck.
Seriously plenty of superb knowledge!|
Thank you for sharing this article with me. It helped me a lot and I love it. http://www.kayswell.com
Someone essentially assist to make significantly articles I might state.
That is the very first time I frequented your web page and to this point?
I amazed with the analysis you made to create this actual publish extraordinary.
Wonderful job!
Visit my blog … eharmony special coupon code 2025
I like the valuable information you supply to your articles.
I will bookmark your weblog and test again right here regularly.
I’m somewhat sure I will learn a lot of new stuff right here!
Best of luck for the following!
Here is my web site; vpn
Hello there I am so happy I found your site, I really found you by mistake, while I was searching on Yahoo for something
else, Anyways I am here now and would just like to say thanks for
a marvelous post and a all round exciting blog (I also love the theme/design), I don’t have time
to go through it all at the minute but I have bookmarked it
and also added your RSS feeds, so when I have time
I will be back to read a lot more, Please do keep up the excellent work.
gamefly https://tinyurl.com/28555853
I very delighted to find this internet site on bing, just what I was searching for as well saved to fav
For the reason that the admin of this site is working, no uncertainty very quickly it will be renowned, due to its quality contents.
I truly appreciate your technique of writing a blog. I added it to my bookmark site list and will
What’s up mates, its wonderful post about educationand completely defined, keep it up all the time.
https://tinyurl.com/23bovxld vpn what is it