The best solution is to create a new instance using characterset UTF8, then exp from your old instances and imp into the new UTF8 instance. You can also try to alter the characterset of your existing instance, but it probably won't work.

See http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76966/appa.htm#969074 for "Universal Character Set" info on 8.1.7.

- Andrew

-----Original Message-----
From: Pankaj Patni [mailto:oracledba-ezmlmshield-x26895579.[Email address protected]
Sent: Wednesday, May 31, 2006 11:06 PM
To: LazyDBA Discussion
Subject: Making Database Multilingual

Hi All

What I want to do
Use Oracle 8i database in 2 languages i.e. English & Korean

What I did
I installed Oracle 8i database and than I connect with sys/change_on_install than
SQL>connect sys/change_on_install as sysdba; shutdown immediate; startup
SQL>mount; alter system enable restricted session; alter system set
SQL>job_queue_processes = 0; alter system set aq_tm_processes = 0; alter
SQL>database open; alter database <database name> character set
SQL>KO16KSC5601;
ERROR at line 1:
ORA-12712:new character set must be a superset of old character set In order to remove this error someone told me to use this query
SQL>alter database <database name> character set password KO16KSC5601;
but still the error is same.

How can I remove this error or is there any other way to use Oracle 8i database in 2 Korean as well as English.

Regards
Pankaj


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree to these terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page