Re: ORA-12712: new character set must be a superset of old character set

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 4 Aug 2003 17:04:51 +0300
Message-ID: <3f2e6807$1_1@news.estpak.ee>

Hi!

You can't do the conversion that way. It is possible to convert US7ASCII to UTF8 for example, because UTF8 is superset of US7ASCII, but not the other way. Go with export - recreate db - import.

Tanel.

"Teresa" <tpreto7_at_sapo.pt> wrote in message news:6dabc692.0307311312.5295b079_at_posting.google.com...
> I have a oracle 9i server running on solaris, and I need to change the
>
> NLS_CHARACTERSET UTF8
> to WE8ISO8859P1
>
> and I get this error message
>
> SQL> alter database character set WE8ISO8859P1;
> alter database character set WE8ISO8859P1
> *
> ERROR at line 1:
> ORA-12712: new character set must be a superset of old character set
>
> Does any one know how I can by pass this problem? I have done it for
> 8x but this is 9i and the docus are not very clear
>
>
>
> Thanks
> Teresa
Received on Mon Aug 04 2003 - 09:04:51 CDT