Question

修改oracle数据库的字符集，现在数据库的字符集为WE8ISO8859P1，需把字符集设置为ZHS16GBK，

如下是我们修改过程：
LN> sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 - Production on Tue Aug 6 10:30:56 2013
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to an idle instance.
SQL> STARTUP MOUNT
ORACLE instance started.
Total System Global Area 826753024 bytes
Fixed Size 2164208 bytes
Variable Size 415238672 bytes
Database Buffers 402653184 bytes
Redo Buffers 6696960 bytes
Database mounted.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
System altered.
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
System altered.
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
System altered.
SQL>
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK
*
ERROR at line 1:
ORA-12721: operation cannot execute when other sessions are active
SQL>

在这我已经跳过超字符集集的检查，但还是提示有问题，请各位大侠帮忙，非常感谢！！

Answer 1

首先，这两个字符集不一定兼容，建议改成UTF8，
然后，改字符集，除非是子集改超集，否则只能重建库，导出导入。

追问

修改为UTF8也报同样的错误：
SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8
*
ERROR at line 1:
ORA-12721: operation cannot execute when other sessions are active

Answer 2

修改字符集那么麻烦啊？