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

From: Dave Hau <davehau_nospam_123_at_nospam_netscape.net>
Date: Thu, 31 Jul 2003 21:35:43 GMT
Message-ID: <3F298BAF.5070205@nospam_netscape.net>

Also take a look at Metalink Note: 225912.1 Changing the Database Character Set - an Overview

Cheers,
Dave

Brian Peasland wrote:

> 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

>
> Received on Thu Jul 31 2003 - 16:35:43 CDT