Re: Export from 9i and import to 8i

I didn't see the original post, but this is not difficult. What "there is no compatibility from 9i to 8i" is supposed to mean, I couldn't say.

But the generic rules (posted ad nauseam to this group in the past few months) are simple: you need to use the LOWER version of export against the HIGHER version of the database to create a lower version dump file. That file can then be imported into the lower version database without a problem.

Short and sweet, therefore: you navigate your way to you Oracle 8i HOME/bin directory and run export from there. Connect to the 9i version database in the usual fashion (connect name/password_at_9idatabasealias. Perform the export. That's an 8i export file, despite it being a 9i database. Now run import against the 8i database, and your problem is solved.

Quite why this requires secret "I have a solution" messages, I don't know. It's pretty standard stuff.

Incidentally, stop cross-posting.

Regards
HJR "nimble ninja" <nimbleninja_at_hotmail.com> wrote in message news:9bbf7c78.0301211351.29a19ac5_at_posting.google.com...
> "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.
>
> No Problem, I have a solution if you havn't found one already. Reply
> to the thread if you're still working on this.
Received on Tue Jan 21 2003 - 16:58:29 CST