Hi All

We are using oracle 8.0.5.0.1 database with US7ASCII character set. we need to change US7ASCII to WE8IS0885P1 character set to support foreign languages. Following is the script i used

shutdown immediate;
startup mount;
alter database enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_procsses=0;
alter database open;
alter database set character set WE8IS0885P1;

But i'm getting the following error message:

ORA-12710: new character set must be a superset of old character set
ALTER DATABASE NATIONAL CHARACTER SET WE8IS0885P1

Any help on this would be greatly appreciated.

regards
srini J

Oracle LazyDBA home page