RE: Not my type- copying user defined types.- HELP!

From: Clarke, Andrew <>
Date: Tue, 18 Nov 2008 13:53:02 +0000
Message-ID: <>


I don't think TOID_VALIDATE will help in your case - that applies to table columns which are built on user-defined types.

I don't think there is a solution using IMP/EXP. As you're on 10g, you could try datapump which does have the transform option which can handle this (see second run below).

clarkea:~$ impdp system remap_schema=APC:XYZ dumpfile=apc_dp_all.dmp

fails ...


ORA-39083: Object type TYPE failed to create with error: ORA-02304: invalid object identifier literal Failing sql is:
CREATE TYPE "XYZ"."TYPE1" OID '5B57AD3BB73CEEB5E040007F01016405' as object (attr1 number, attr2 number);

Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 2 error(s) at 13:23:44

clarkea:~$ impdp system remap_schema=APC:XYZ dumpfile=apc_dp_all.dmp transform=oid:n


Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 13:28:18

(The 1 error is the prior existence of the XYZ schema)

Cheers, APC

A P Clarke
Software Architect
Logica UK Public Sector Division
250 Brook Drive,
Green Park,

Direct Tel: +44 (0)207 230 3160
Fax: +44 (0)207 446 1352

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.

Received on Tue Nov 18 2008 - 07:53:02 CST

Original text of this message