Database Utilities (MOSC)

MOSC Banner

Import 9i exported table with XMLTYPE datatype into 11g

edited Mar 30, 2011 4:43AM in Database Utilities (MOSC) 5 commentsAnswered
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? 

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