Database Utilities (MOSC)

MOSC Banner

Importing table with XMLtype - error

edited Oct 8, 2009 3:34AM in Database Utilities (MOSC) 2 commentsAnswered

 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center