Re: Importing from Oracle9i to Oracle8.0

"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
Received on Wed Nov 20 2002 - 13:43:25 CST