Re: ORA-24329: invalid character set identifier

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Wed, 24 Sep 2003 04:28:37 +0300
Message-ID: <3f70f346_1@news.estpak.ee>

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" <member40260_at_dbforums.com> wrote in message news:3387849.1063920006_at_dbforums.com...
>
> 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
Received on Tue Sep 23 2003 - 20:28:37 CDT

Re: ORA-24329: invalid character set identifier - Please help