RE: Export throws EXP-41 error.
- From: <arul.kumar@xxxxxx>
- To: <Tony.Adolph@xxxxxx>, <GJohnson@xxxxxxx>
- Date: Tue, 21 Dec 2004 10:12:37 -0000
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@xxxxxx [mailto:Tony.Adolph@xxxxxx]
Sent: 21 December 2004 10:04
To: Kumar,A,Arul,XGF3C C
Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
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@xxxxxx
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
12/21/2004 10:56 AM
Please respond to
arul.kumar@xxxxxx
To
oracle-l@xxxxxxxxxxxxx
cc
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.
--
<//www.freelists.org/webpage/oracle-l>
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
