During
impdp we get:
ORA-39083:
Object type TYPE failed to create with error:
ORA-02304:
invalid object identifier literal
Failing sql
is:
CREATE TYPE …
Fix it by
adding TRANSFORM parameter on impdp:
impdp system/welcome@orcl
directory=DUMPDIR dumpfile=mydump.dmp logfile=import01.log schemas=ABC TRANSFORM=OID:N:TYPE
No comments:
Post a Comment