RE: Not my type- copying user defined types.- HELP!
Date: Tue, 18 Nov 2008 13:53:02 +0000
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
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)
A P Clarke
Logica UK Public Sector Division
250 Brook Drive,
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