修改数据库字符集出错?

zszhx

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter system enable restricted session;

System altered.

SQL> alter system set job_queue_processes=0;

System altered.

SQL> alter database character set ZHS16GBK;
alter database character set ZHS16GBK
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set

请教高手?
原来的字符集不支持中文显示,为何?
NLS_CHARACTERSET               WE8ISO8859P1
NLS_NCHAR_CHARACTERSET         AL16UTF16

macrodba

从新建立控制文件来修改字符集，在从新建控制文件的时候先备份以防万一！
alter database backup controfile to '/tmp/controlfilebak.ctl'
alter database backup crontrofile to trace;
察看生成的跟踪文件，内容为你建立控制文件的脚本