Re: Export from 9i and import to 8i

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Tue, 14 Jan 2003 20:00:39 -0000
Message-ID: <3e247a0a$1_1@mk-nntp-1.news.uk.worldonline.com>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:kqEU9.23373$jM5.61750_at_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
>

Howard,

It used to be necessary to run catexpvv on the higher version database (where vv is the lower version) in order to create the necessary views for the lower version exp to use.

Is this done automatically now?

Regards,
Paul Received on Tue Jan 14 2003 - 14:00:39 CST