Re: Exporting Version 7.0 DB to Version 6.0
Date: Mon, 27 Mar 1995 14:48:06 GMT
Message-ID: <D63t47.72x_at_lanier.com>
In article <sminkeyk.72.000DA4E3_at_interramp.com>,
Mark Sminkey <sminkeyk_at_interramp.com> wrote:
>After exporting some Oracle 7.1.4 tables and then trying to import them
>into our Version 6.0.36 database I got errors to the effect: cannot convert
>from nls_lang type 3 to 1 or something like that.
>
>My question is this : Can you export a Version 7.0 database and then
>import it into a Version 6.0 database? If so, how?
>
We have done something like this by running the export with the Version 6 software, connecting to the Version 7 instance by appropriate settings of the TWO_TASK environment variable. The Version 6 exp program appears to be able to read the Version 7 database in our case, but we eventually opted to use 'create table xxx as select ... from [V7_table_at_dblink]' instead. This seems to be faster and cleaner than using export/import.
Don
Donald E. Vick (dvick_at_lanier.com, dvick_at_crl.com) Voice: (404) 493-2194 Fax: (404) 493-2399 Received on Mon Mar 27 1995 - 16:48:06 CEST