Re: How I can do it:

"Ariel" <a_at_a.com> wrote in message news:anrg6k$rar$1_at_news2.tpi.pl...
> Hi!
>
> I want to import "one schema objects" from Oracle 9i EE database to Oracle
> 8.1.7 EE database?
> How I can do it?
>
> Plain export/import don't work.
>

The phrase 'it doesn't work' is singularly unhelpful. About as useful as me replying that 'it should work'.

I'm not sure that "one schema objects" means exactly, but if it means you are trying to get hold of a single table, or a single schema, then export and import should have no problem provided you follow the usual rules: you have to use the *earlier* version of export against the *higher* version of the database.

Meaning that you have to be in the 8i ORACLE_HOME/bin directory when you type 'exp', to make sure you launch the 8i version of export. You then connect export to the 9i database and proceed as usual. At the end of it, you have an 8i-compatible export dump file, and the 8i version of import should have no problem importing that into an 8i database... provided you aren't trying to export 9i-specific data structures (such as ASSM bitmaps, etc).

Regards
HJR
> Ariel.
>
>
Received on Mon Oct 07 2002 - 04:49:17 CDT