Problem
Import hangs on stage:
Processing object type DATABASE_EXPORT/SCHEMA/JAVA_CLASS/GRANT/OWNER_GRANT/OBJECT_GRANT
At the same time, the impdp worker session is blocked by itself and is waiting on event 'library cache pin', as seen from the v$session view
Solution
Perform import in two phases, like:
$ impdp ... exclude=JAVA_CLASS
$ impdp ... include=JAVA_CLASS
Import will finish successfully
No comments:
Post a Comment