Re: Losing characters on Import

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Oct 2001 22:40:02 +0200
Message-ID: <ts9dfal17fqodc@news.demon.nl>

"Oscar Barlow" <obarlow_at_metasolv.com> wrote in message news:8cc6ac2e.0110101149.b6c0005_at_posting.google.com...
> I have an export of a DMP file from Brazil that was done on Solaris
> using oracle 8.1.6. I run the import on Linux using oracle 8.1.7.
> All the characters unique to Portuguese where changed. For example,
> Não was changed to N?o. If I ran the import on Windows2000 using
> oracle 8.1.6, it worked fine.
>
> Any suggestions? A bug in Linux/oracle?
>
> Thanks,
> Oscar Barlow
> obarlow_at_metasolv.com

Wrong or missing NLS_LANG during export and/or import. So : user error.
Do you still have the logs of those sessions? Would prove it easily.

Regards,

Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 10 2001 - 15:40:02 CDT