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.