不重装数据库能直接修改DB字符集

SVRMGR> SHUTDOWN IMMEDIATE;
SVRMGR> STARTUP MOUNT;

SVRMGR> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SVRMGR> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SVRMGR> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SVRMGR> ALTER DATABASE OPEN;
SVRMGR> ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
SVRMGR> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE ZHS16GBK;
SVRMGR> SHUTDOWN IMMEDIATE;
SVRMGR> STARTUP RESTRICT;
SVRMGR> SHUTDOWN IMMEDIATE;
/*
The double restart is necessary because of a SGA initialization bug, fixed in Oracle9i.
@ This is .
*/
SVRMGR> STARTUP