修改字符集的步骤如下:
例如:修改当前字符集SIMPLIFIED CHINESE_CHINA.AL32UTF8为SIMPLIFIED CHINESE_CHINA.ZHS16GBK
1、sqlplus / as sysdba
2、shutdown immediate;
3、startup mount;
4、alter system enable restricted session;
5、alter system set JOB_QUEUE_PROCESSES=0;
6、alter system set AQ_TM_PROCESSES=0;
7、alter database open;
8、ALTER DATABASE CHARACTER SET ZHS16GBK;(这一步执行会失败,可以忽略)
9、alter database character set internal_use ZHS16GBK;
10、shutdown immediate;
11、startup