Re: [exp-Imp] export in Oracle 8.1.7 - import to Oracle 8.1.6 ?

Carsten Jacobs wrote:
>
> Hello,
>
> I'm facing the problem to export a database ( user level) in Oracle 8i 1.7
> and import it to Oracle 8i 1.6 .
> This doesn't work. The export and import commands are ok because an import
> in 8.1.7 works perfect.
>
> Is there any solution for that. Maybe third party programms that could help?
>
> Thanks for any help
>
> Carsten

Carsten,

There is a parameter in the init.ora named "compatible". I believe that if you set that value as:

compatible=8.1.6

and bounce the instance that you will be able to produce an export usable by an 8.1.6 imp.exe.

Sybrand's recommendation of using the 8.1.6 exp.exe binary to produce the export from the 8.1.7 database is best. You might still want to set the compatible parameter also.

Paul Received on Sat May 05 2001 - 13:48:46 CDT