Re: Q: Migrating a DB with EXP/IMP

Uwe Schneider wrote:
>
> Hi experts,
>
> I try to migrate a complete Oracle database from a 7.2.2 server under
> AIX to 7.3.2 under Solaris (Sparc).
>
> I estimate the exp/imp utilities are fitting the best for this purpose.
> Unfortunately I experience NLS problems:
> The export dump file does contain 8 bit chars, but after the import all
> 8 bit characters are converted to 7 bit chars.
>
> This happens with or without setting NLS_LANG before invoking imp
> to the value it had during export.
>
> As a hint I can tell you that clients that connect to the target
> database need to _unset_ NLS_LANG before connecting to the database in
> order to get 8 bit select sets.
>

In the meantime the problem is more obvious: The 7.3 DB on the Sun war installed without NLS functionality. Therefore my target is now an 8-bit export of these data (followed by a import into a correctly installed database).

My tests show: The exp-Output on the SUN contains 8-bit data if and only if NLS_LANG is unset, but input into a NLS-able database is 7-bit, since exp seems to note the character set in the export file.

Are there any techniques to avoid this?

Uwe Received on Wed Oct 28 1998 - 10:19:49 CST