Home » RDBMS Server » Server Administration » Changing Character set
Changing Character set [message #321580] Tue, 20 May 2008 14:48 Go to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member
Hi Friends,
i am new to this forum. and i have a doubt that i like to change the character set in oracle 10g from AL32UTF8 to WE8MSWIN1252.

When i used the following command, i received a error,

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

Please give me a solution for this.

Thanks in Advance,

Seenu
Re: Changing Character set [message #321587 is a reply to message #321580] Tue, 20 May 2008 15:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
When i used the following command

Which one?

Quote:
ORA-12712: new character set must be a superset of old character set
Cause: When you ALTER DATABASE ... CHARACTER SET, the new character set must be a superset of the old character set. For example, WE8ISO8859P1 is not a superset of the WE8DEC.
Action: Specify a superset character set.


WE8MSWIN1252 is NOT a superset of AL32UTF8, you can't do that, you have to recreate the database.

Regards
Michel
Re: Changing Character set [message #321605 is a reply to message #321587] Tue, 20 May 2008 19:35 Go to previous messageGo to next message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Thanks a lot michel.

Is there any other way to change the character set than recreate the database because its production database.


Thanks and Regards,

Seenu
Re: Changing Character set [message #321611 is a reply to message #321580] Tue, 20 May 2008 19:51 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Is there any other way to change the character set than recreate the database
There is NO other way.
Re: Changing Character set [message #321843 is a reply to message #321611] Wed, 21 May 2008 08:39 Go to previous message
srini_thiru
Messages: 133
Registered: May 2008
Senior Member

Thank u very much..

Seenu
Previous Topic: Migration
Next Topic: list trace events
Goto Forum:
  


Current Time: Fri Dec 09 07:47:58 CST 2016

Total time taken to generate the page: 0.13451 seconds