How to Export Import table with XMLtype ?
stacyzJul 27 2009 — edited Jul 28 2009I have an oracle 10g database with a table that has an XMLType column. I have to use the old exp / imp to copy the data to another schema in the same instance. However, I am having issues because of the types that are created when the developer registers an XML schema.
How can I import the data to a new schema? I am going to have to do this regularly to refresh test environments. Metalink offered doc id 1066139.6 but none of these solutions is feasible for us. Does anyone else have a workaround this issue or know if 11g handles this differently?
The error I see is ORA-02304 - due to the fact that the type OID for the type already exists when the import tries to create it in the new schema (Schema B). I can't drop any types from Schema A as that is a valid schema that is in use.
ORA-02304 : invalid object identifier literal - an object identifier that already identifies an existing object or an object identifier different from the original object identifier already assigned to the type
Thanks for any suggestions.