Re: Export throws EXP-41 error.

Hi,

        in my opion it's not a bug and you have two options 1) remove the direct parameter from the shell 2) set your NLS_LANG env variable accordingly to the database character set being exported.
Giovanni

> 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
>
>

-- 

----------------------------------------
Giovanni Cuccu
Sw Engineer_at_dianoema.it
Dianoema S.p.A.
Via de' Carracci 93 40131 Bologna
Tel: 051-7098211   051-4193911
e-mail:gcuccu_at_dianoema.it
----------------------------------------
No man does it all by himself,
I said young man,
put your pride on the shelf
----------------------------------------
--
http://www.freelists.org/webpage/oracle-l