Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Export from 8.0.5 to 7.3.4

Export from 8.0.5 to 7.3.4

From: Jim Conboy <Jim.Conboy_at_trw.com>
Date: Tue, 09 Jan 2001 12:36:08 -0800
Message-Id: <10736.126202@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US