Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!feeder.qis.net!sn-xit-02!sn-post-01!supernews.com!news.demon.nl!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.misc Subject: Re: Losing characters on Import Date: Wed, 10 Oct 2001 22:40:02 +0200 Message-ID: Reply-To: "Sybrand Bakker" References: <8cc6ac2e.0110101149.b6c0005@posting.google.com> X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Complaints-To: abuse@nl.demon.net NNTP-Posting-Host: sybrandb.demon.nl X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78 X-Trace: news.demon.nl 1002747370 news:13648 NO-IDENT sybrandb.demon.nl:212.238.21.78 Lines: 28 Xref: easynews comp.databases.oracle.misc:70150 X-Received-Date: Wed, 10 Oct 2001 13:57:45 MST (news.easynews.com) "Oscar Barlow" wrote in message news:8cc6ac2e.0110101149.b6c0005@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@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