Re: Char sets and the direct export - is there a workaround?

Hi,

"David Van Zandt" <dvanzandt_at_iquest.net> wrote in message news:baxm7.486$be6.233257_at_news1.iquest.net...

> I was trying to set up a common export parameter file for multiple
> databases, using the direct=y switch. Obviously this fails for those
> instances that have a character set other than the host o/s (HPUX).
>
> In SQLPlus I would of course simply alter the session. But from the o/s
> command prompt, not an option that I'm aware of.
>
> Ideas gratefully welcomed, and thanks.

have to set NLS_LANG variable, i.e
export NLS_LANG=AMERICAN_AMERICA.WE8DEC (in KSH) All oracle tools (sqlplus,svrmgrl,imp,exp,...) will use this.

It's not a workaround, but the way direct=y needs it ...  

Hth
 Thomas

-- 
Posted from  [212.20.131.226] 
via Mailgate.ORG Server - http://www.Mailgate.ORG