Today while trying to copy a schema (in same instance using impdp) i got the following error
CREATE TYPE ""T2."NAME_AND_COUNT" OID 'B39B42D096902425E0409C0AF60C2DB0' IS OBJECT ( OBJECT_NAME varchar2(30), UPDATE_COUNT INTEGER);ORA-39083: Object type TYPE failed to create with error:ORA-02304: invalid object identifier literalFailing sql is:CREATE TYPE "T2"."OBJECTIDLIST" OID 'B39B42D096992425E0409C0AF60C2DB0' IS TABLE OF INTEGER;ORA-39083: Object type TYPE failed to create with error:ORA-02304: invalid object identifier literal
Cause : Oracle was trying to import an object with OID which already existed in database. Since i was copying the user t1 to user t2 no surprise that the OID already existed. And OID should be unique in a database.
Solution : I added the clause transform=OID:n in my impdp command.
example : -impdp T2/T2@Tesddb REMAP_SCHEMA=T1:T2 VERSION=10.2 DIRECTORY=DMP LOGFILE=impdp.log.log JOB_NAME=t1tot2_job transform=OID:n
DUMPFILE=t1exp.dmp
Everything went fine after that.
Ankur
Subscribe to:
Post Comments (Atom)
Thank you, it helps me.
ReplyDeleteThis comment has been removed by the author.
ReplyDeletewow, its working , thanks a lot .
ReplyDeleteRight in the nail, help me too.
ReplyDeleteThanks adding transform=OID:n worked for me
ReplyDeletethank you,got the import without error.
ReplyDeleteGreat! Thank you from Russia!
ReplyDelete