RE: Export throws EXP-41 error.

From: <arul.kumar_at_bt.com>
Date: Tue, 21 Dec 2004 10:12:37 -0000
Message-ID: <83FC2D1BC95D884894735B11B562A41C09D869AA@i2km06-ukbr.domain1.systemhost.net>

Tony, George,

Thanks a lot. It works.

SQL> select value$ from props$ where name in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET'); VALUE$

ENGLISH
UNITED KINGDOM
UTF8 export NLS_LANG=ENGLISH.UTF8

Thanks,
Arul.

-----Original Message-----
From: Tony.Adolph_at_o2.com [mailto:Tony.Adolph_at_o2.com] Sent: 21 December 2004 10:04
To: Kumar,A,Arul,XGF3C C
Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org Subject: Re: Export throws EXP-41 error.

Doesn't look like a bug to me: your shell NLS settings don't match the database's. Try setting NLS_LANG=<some language>.UTF8 export NLS_LANG and try again.

Cheers
Tony

arul.kumar_at_bt.com
Sent by: oracle-l-bounce_at_freelists.org

12/21/2004 10:56 AM

Please respond to
arul.kumar_at_bt.com

To
oracle-l_at_freelists.org

Subject
Export throws EXP-41 error.

Hi DBAs,

I think it is a bug. But, just in case if anyone has a workaround for this problem.

Export throws the following error when I use a DIRECT=3DY parameter. Has

anyone faced this?=20

Environment :

OS - HP -UX B.11.11
RDBMS - 8.1.7.4.0 /usr/sbin/mknod ARUL.pipe p
nohup cat ARUL.pipe | gzip -9 > exp_svce_att_value.dmp.gz 2>&1 & nohup exp sidb_d01/xyz file=3DARUL.pipe tables=3Dsvce_att_value = compress=3Dn
rows=3Dy direct=3Dy > exp_svce_att_value.log 2>&1 &

cat exp_svce_att_value.log

EXP-00041: Export done in server's UTF8, different from user's character

set US7ASCII
EXP-00000: Export terminated unsuccessfully

Thanks,
Arul.

-- 
 <http://www.freelists.org/webpage/oracle-l>
http://www.freelists.org/webpage/oracle-l 





--
http://www.freelists.org/webpage/oracle-l

Received on Tue Dec 21 2004 - 04:06:59 CST