Forgot to add this the other day when I came across this interesting feature ( :-/ ) oracle.
Import (impdp) was failing with:
ORA-39002: invalid operation
ORA-39165: Schema SCHEMA_NAME was not found.
Took me a while to figure out why I was getting that error.
Went thru EXPDP log and find that the similar error in there too:
ORA-39165: Schema SCHEMA_NAME was not found.
Interestingly, That schema has no objects and thus EXPDP was erroring with that error and thus the IMPDP too.
Removed these schema(s) from the IMPDP list and import went thru fine...
Import (impdp) was failing with:
ORA-39002: invalid operation
ORA-39165: Schema SCHEMA_NAME was not found.
Took me a while to figure out why I was getting that error.
Went thru EXPDP log and find that the similar error in there too:
ORA-39165: Schema SCHEMA_NAME was not found.
Interestingly, That schema has no objects and thus EXPDP was erroring with that error and thus the IMPDP too.
Removed these schema(s) from the IMPDP list and import went thru fine...
No comments:
Post a Comment