Re: Oracle 7.3 exp file to Oracle 8

From: Jamie Schrumpf <hatterasNOSPAM_at_hotbot.com>
Date: 9 Dec 1999 22:02:02 GMT
Message-ID: <82p8sq$hv2$5@holly.prod.itd.earthlink.net>

In article <38501FA7.C021B3E_at_entrasoft.com>, cjdeschenes_at_entrasoft.com says...
>
>Is it possible to import an Oracle 7.3 dump into an Oracle 8 database?
>The migration assistants expect to have access to a 7.3 installation.
>
>Thanks
>

Sure is. I do this all the time between 7.3.3 and 8.1.5.

There may be an even simpler way, but I have two scripts that reset ORACLE_HOME, ORACLE_SID, PATH, and LD_LIBRARY_PATH from the 7.3.3 version to the 8.1.5 version, and vice versa. I export with the 7.3.3 settings, then import with the 8.1.5 settings.

Works like a champ. Of course, I'm using exp and imp, not the migration assistant. YMMV.
--

---

Jamie Schrumpf Received on Thu Dec 09 1999 - 16:02:02 CST