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
Monday, 19 December 2011
Subscribe to:
Comments (Atom)