Re: Export from 9i and import to 8i

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 14 Jan 2003 06:37:29 +1100
Message-ID: <kqEU9.23373$jM5.61750@newsfeeds.bigpond.com>

First: don't crosspost.
Second: take a trip to your 8i ORACLE_HOME/bin directory, and invoke exp from there. Connect to the 9i database by using a regular tnsnames alias. You are now running 8i export against the 9i database, meaning that you will end up producing an 8i dump file.

That will import into an 8i database without a problem.

The rule is: higher versions of export cannot be run against lower versions of the database. But it's not a problem to run the lower version of export against the higher version of the database.

Regards
HJR "Sasa Golub" <fotogolub_at_yahoo.com> wrote in message news:avuq4g$oaf$1_at_news.eunet.yu...
> Hi,
>
> I want to export database from Oracle 9i and import it on Oracle 8i, but
> there is no compatibility from 9i to 8i. So, if anyone knows how can I do
it
> (without manual "create table -- as select * from -- @--") I would be very
> greatfull.
>
> Thanks,
>
> Sasa.
>
>
Received on Mon Jan 13 2003 - 13:37:29 CST