Home » RDBMS Server » Server Administration » superset of WE8MSWINI1252
superset of WE8MSWINI1252 [message #150237] Tue, 06 December 2005 20:52 Go to next message
juicyapple
Messages: 92
Registered: October 2005
Member
I would like to change my current database character set (WE8MSWINI1252) to AL32UTF8.

I try alter database <database name> character set <new character set name> but it return AL32UTF8 is not superset of the current character set.

How to ensure the AL32UTF8 is a strict superset of WE8MSWINI1252?

Report message to a moderator

Re: superset of WE8MSWINI1252 [message #150474 is a reply to message #150237] Thu, 08 December 2005 01:07 Go to previous message
dbaxchangedba
Messages: 26
Registered: November 2005
Junior Member
One option for you is to use the internal_use option while doing the characterset change but that requires for you to do extensive pre-work to make sure there will be no data corruption due to the characterset change. You can find details on what needs to be done at the link below:

http://www.dbaxchange.com/2_3_charactersetchange.htm

Good Luck!

http://www.dbaxchange.com
(one stop site for practical solutions to oracle issues, oracle
Facts, White Papers, Book recommendations, International job search site recommendations and much more....)

Report message to a moderator

Previous Topic: Convert locally managed system tablespace to Dictionary managed tablespace
Next Topic: view the segment temp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 13:27:59 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.