import from 9.2 to 8.1.7

[pavelcoan]

I exported a dmp file from the version 9.2 and then i tried to import it to a server that has installed an older version:8.1.7 but i cant make it work.
what should i do?

 

[karluk]

As a general rule, if you want to import into an earlier release of Oracle, you should first do an export using the earlier release. Probably you did the export with the Oracle 9.2 export utility.

 

[markco]

you should use Oracle817 export tools, connect to 9i DB and do the export. Then use 817 import tools to import into 817 DB.
Markco Wong

 

[raygg]

I found that this works fine - as long as you only specify the individual schema names ex: owner=(aa,bb,etc). Because 9i differs significantly from 8i, you cannot specify full=y on the export using the 8i exp program - it fails - it cannot get past the initial 9i system related stuff - like rollbacks, system procedures etc prior to the SYSTEM schema.