Re: Exporting Version 7.0 DB to Version 6.0

In article <sminkeyk.72.000DA4E3_at_interramp.com> Mark Sminkey, sminkeyk_at_interramp.com writes:
>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?
>
>Thanks in advance
>
>-Mark

You have to:

1. Define the ORACLE6 export views.

   ORACLE7 comes with the catexp6.sql script that defines the oracle6 export

   views. Run it as SYS. It should be in ORA_RDBMS (VMS) or    $ORACLE_HOME/rdbms/admin.

2. Run the export using the ORACLE6 EXP executable.

   I find the easiest way to do this is to do the export across SQL*Net.    Point the the V6 database using orauser (VMS) or oraenv (UNIX) then run    the export, giving the sql*net connect string to the V7 database.

        $ exp scott/tiger_at_t:fred.lilly.com:dev

   Another approach, which I have not used, would be to try to move the V6

   exp executable into the V7 root. You would obviously need to give it a new

   name so that it doesn't conflict with the V7 exp. In VMS, you would put it

   in ORA_RDBMS. In UNIX you would put it in $ORACLE_HOME/bin. This might

   not work at all because the v6 executable would have been linked against a

   v6 kernel, not the v7 kernel.

Bob Swisshelm | swisshelm_at_Lilly.com | 317 276 5472 Eli Lilly and Company | Lilly Corporate Center | Indianapolis, IN 46285 Received on Sat Mar 25 1995 - 19:01:38 CET