Import 9i exported table with XMLTYPE datatype into 11g
I need to extract some data from prior to our 11g migration. The import of the 9i full export is failing claiming the table doesn't exist after it creates the table. I recall this issue with CLOB's with 9i, but don't recall the fix. The table is created in its original schema and tablespace with indexes and constraints. There is normally a trigger on the table, but I removed the trigger since it was a trigger to catch errors. The export is a full database export, I don't have a export of this individual table.
Any ideas on how to get around the error?
Any ideas on how to get around the error?
0