ORA-24329: invalid character set identifier - Please help

[vortex_sea]

Hi,

I am new to this forum and also to Oracle. I have a query regarding the
above error. I am getting this, when I try to move data from Oracle
8.1.7.4 (charset/NLS charset - US7ASCII/US7ASCII) to Oracle 9.2.0.3
(charset/NLS charset - US7ASCII/AL16UTF16).

Please note that I am not doing an upgrade. Please help in resolving
this. any input appreciated.

--Vortex_Sea

--
Posted via http://dbforums.com

[Amit]

The difference is that your old Oracle server was using a ASCII characterset
for NCHAR/NVARCHAR type columns and 9i is using AL16UTF16 (which is 16-bit
unicode).

Do you have any setting in your environment for NLS_LANG or NLS_NCHAR ?

You can get by using the implicit translation in Oracle. You need to set
NLS_LANG environment variable to something like
AMERICAN_AMERICA.WE8ISO8859P1.

If this alone doesn't works try also adding NLS_NCHAR variable equal to
OCI_UTF16ID (I think).

Take a look at this: http://technet.oracle.com/tech/oci/htdocs/oci_faq.html

- HTH

------------------------------------------------------
Amit Jindal, Development Engineer

Powerful, yet easy. Superior C++ database development.
http://www.roguewave.com/products/sourcepro/db/

[Disclaimer: All views expressed here are my personal
views and they can be incorrect at times]
------------------------------------------------------

"vortex_sea" <membe...@dbforums.com> wrote in message
news:3387849.1...@dbforums.com...

[Tanel Poder]

Hi!

There is no AL16UTF16 charset in 8i. You can verify it from
v$nls_valid_values view.

Set your client's NLS_LANGs charset to US7ASCII as well, you should be able
to query your source database that way and insert data to target without
problems (providig that there is only us7ascii data in your us7ascii
database).

Tanel.

"vortex_sea" <membe...@dbforums.com> wrote in message
news:3387849.1...@dbforums.com...
>