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

Your "workaround" is to export the database contents, recreate the database with the new character set, and import. More information can be found in Metalink Note: 119164.1 Changing Database Character Set - Valid Superset Definitions.

HTH,
Brian

Teresa wrote:
>
> 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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"