修改oralce11g 字符集为ZHS16GBK

SQL> conn sys/sys as sysdba;
SQL> shutdown immediate;
SQL> STARTUP MOUNT;
SQL> ALTER SESSION SET SQL_TRACE=TRUE;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL> Alter database open;
SQL> ALTER DATABASE CHARACTER SET ZHS16GBK;

SQL> Shutdown immediate;
SQL> startup;oracle数据库的字符集更改

SQL> ALTER DATABASE CHARACTER SET ZHS16GBK; 如果失败 就业下一个

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

ALTER DATABASE character set INTERNAL_USE ZHS16GBK;

 

select userenv('language') from dual