Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Setting NLS_LANG on W2000

Re: Setting NLS_LANG on W2000

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 9 Oct 2001 18:43:29 +0200
Message-ID: <ts6bdboposgd8d@news.demon.nl>

"vg" <vgalan_at_personal.ro> wrote in message news:54e5e6b4.0110090607.2811e889_at_posting.google.com...
> Hello there!
>
> I read all the messages in this group before I decided to post this
> message, so please bear one more NLS related question...
>
> My goal:
> - export from a UTF8 database some tables and then import this data
> into a UTF8 database
>
> My system's configuration (both DBs):
> - NLS_LANGUAGE=AMERICAN
> - NLS_CHARACTERSET=UTF8
> - NLS_NCHAR_CHARACTERSET=UTF8
>
> (extracted from 'select * from sys.props$')
>
> - system variable NLS_LANG set to UTF8
> - in Registry, i have the following keys:
>
> HKLM\Software\Oracle\NLS_LANG=AMERICAN_AMERICA.UTF8
> HKLM\Software\Oracle\ALL_HOMES\ID0\NLS_LANG=AMERICAN_AMERICA.UTF8
> HKLM\Software\Oracle\HOME0\NLS_LANG=AMERICAN_AMERICA.UTF8
>
> When I try to connect to DB to export, the sqlplus fails with error
> "ERROR:
> ORA-12705: invalid or unknown NLS parameter value specified"
>
> However, the DBA Studio works just fine...
>
> Finally, when I try to export a table (only the table's rows), all I
> get is:
>
> EXP-00056: ORACLE error 12705 encountered
> ORA-12705: invalid or unknown NLS parameter value specified
> EXP-00030: Unexpected End-Of-File encountered while reading input
> EXP-00000: Export terminated unsuccessfully
>
> If you see something wrong in my settings, please give me a
> clue...because I'm stuck! :-((
>
>
> Thank you for your time!
>
> VG.

Try select * from v$nls_valid_values
this will show what is available to you. This might also be a client issue.

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Tue Oct 09 2001 - 11:43:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US