Home » RDBMS Server » Server Administration » Changing NLS_CHARACTERSET on Xepress Edition
icon5.gif  Changing NLS_CHARACTERSET on Xepress Edition [message #196637] Fri, 06 October 2006 05:42 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
Dear all,

I tried to install oracle XE on windows2003 and got any problem as the following:
1. Is the oracle XE created database used NLS_CHARACTERSET = AL32UTF8 by default?

2.I tried to change it to TH8TISASCII by :

sql>alter database fujudb character set TH8TISASCII;
ORA-12712: new charactor set must be a superset of old character set

3. Is there any way to solve it?

Thanks for advance !

Chara
Re: Changing NLS_CHARACTERSET on Xepress Edition [message #196755 is a reply to message #196637] Sat, 07 October 2006 01:08 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

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.
Previous Topic: Multiple Oracle Instances on one server
Next Topic: Oracle XE - Can't "Go to Database Home" ?
Goto Forum:
  


Current Time: Mon Dec 05 13:08:48 CST 2016

Total time taken to generate the page: 0.09772 seconds