Importing table with XMLtype - error
I am trying to copy a schema to another empty schema using exp and then the imp utilities. One of the tables has an xmltype column.
I am seeing an error when doing the import as first it is trying to recreate the types associated with this table as they already exist in the other schema.
I've read metalink doc 1066139.6 which explains why I am getting this error and the possible solutions but none of these solutions will work for me as I need the type in both schemas (they are both in the same database instance/db server). There are 150+ types so I can't see that using the TOID_NOVALIDATE is feasible in this case.