Re: Importing from Oracle9i to Oracle8.0

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3tRC9.80642$g9.227215_at_newsfeeds.bigpond.com...
>
> "Juergen Diet" <jdiet_at_acm.org> wrote in message
> news:17fc941f.0211200533.2cc352af_at_posting.google.com...
> > Hi,
> > is Oracle's export/import-utility backward compatible?
>
> Depends what you mean. The rule is: you must use the lower version of
export
> against the higher version of the database in order to produce a
> low-version-compatible dump file.
>
> > I want to export a user of an Oracle9i database and
> > import him into an Oracle8.0.5 database. Is this
> > possible if I did not use any 9i-specific features
> > for this database user?
>
> So, using the above rule, you go to the Oracle 8.0.5 HOME/bin directory
and
> launch export from there. Connect to the 9i database as per normal (using
> tnsnames alias if necessary) and perform your export. That gets you an
> 8.0-compatible dump file, and yes... as you'd expect, that can be imported
> into the 8.0.5 database.
>
> Whether the user has made use of 9i specific features or not is therefore
> irrelevant: the 8.x version of export will not be able to cope with any
that
> it finds in any case, and will throw an error for that particular object
and
> then just keep on going. The dump file won't, in other words, contain any
> 9i-specific features even if the user had any.
>
> Regards
> HJR
>
>
>
>
> > Thanks,
> > Juergen
>
>

All the above is right, but usually one has to go into the higher version database first, and run catexpnn, where nn is the lower version. This is to fool the nn exp binary by creating a set of nn-compatible views.

Regards,
Paul Received on Wed Nov 20 2002 - 15:47:50 CST