Re: Characters losts during Import (8.1.6) -> (9.2.0.6)

Sybrand Bakker wrote:
> On Wed, 05 Jul 2006 14:46:51 +0200, Cris Carampa
> <cris119_at_operamail.com> wrote:
>
> >I know this is the correct method, but going that way the OP would lose
> >all the French characters, because, according to my experience, imp on
> >the "target" database (which is WE8ISO8859P1) will truncate all the
> >8-bit characters of a US7ASCII export file during import. That's why I
> >suggested SQL*Loader.
>
>
> If that would have been true, your advice is NOT going to work, as
> SQL*Loader uses *exactly* the same mechanism.
> The OPs problem probably is he is storing 8 bit characters in a 7 bit
> database. That has nothing to do with exp/imp not being capable of
> converting a characterset.
> You are spreading fairy tales.
>
> --
> Sybrand Bakker, Senior Oracle DBA

What do you mean by sql*loader uses the same mechanism? Consider this:

• exp done using NLS_LANG us7ascii. Oracle will record in the dmp file that exp was done using us7ascii. If imp then uses 8859, oracle will report charset conversion.

as compared to:
* Data unloaded with nls_lang as us7ascii (no charset conversion as   same charset is being used).
  Then use sql*loader and specify nls_lang as 8859. Again, no charset   conversion.

the difference is that oracle exp will record the nls_lang setting.

So Cris's solution might work.

Anurag Received on Wed Jul 05 2006 - 12:36:46 CDT