Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Export from 8.0.5 to 7.3.4
I've been asked to do the above Bad Thing (bad because I'm going from one =
expired version to another). Ran the catexp7.sql in 8.0.5 and used the =
7.3.4 export utility. All went well until I got a flurry of messages =
like:
EXP-00018: datatype (0) for column UPDATE_RATIONALE, table POINT_OF_CONTACT= is not supported=20
This is because the 8.0.5 database has VARCHAR2 columns of length 4000 and = 7.3.4 only supports up to 2000. A quick check of max column lengths = reveals that yes, in fact some of the columns are actually >2K in length. = I suppose I can make them truncate to 2000 and change the data lengths, or = convert the >2000 columns to the dreaded long fields. Does anyone have a = better solution? Thanks. Received on Tue Jan 09 2001 - 14:36:08 CST