Was facing the following errors while impdp. Reason for this error is OID should be unique in each DB. In this case, OID in the impdp was using old schema value thus failing.
ORA-39083:
Object type TYPE failed to create with error:
ORA-02304:
invalid object identifier literal
Solution is to use transform=OID:n on my impdp parameter.
Example :
impdp
username DIRECTORY=DUMP transform=OID:n DUMPFILE=schema.dmp
Now all good!
No comments:
Post a Comment