Re: Export from 9i and import to 8i

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message news:3e247a0a$1_1_at_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.

There certainly used to be a catexp7.sql script which you had to run in the higher database in order for a version 7 export to work against it.

But there never was catexp8, or catexp81. So quite what happens in that respect, I don't honestly know. I've performed many 8.0-8i-9i exports without running any such scripts, and have never had a problem.

Regards
HJR Received on Tue Jan 14 2003 - 16:32:14 CST