Setting NLS_LANG on W2000

From: vg <vgalan_at_personal.ro>
Date: 9 Oct 2001 07:07:33 -0700
Message-ID: <54e5e6b4.0110090607.2811e889@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. Received on Tue Oct 09 2001 - 09:07:33 CDT