更改oracle字符集

修改为16GBK:

1，用sys登录 sqlplus / as sysdba

2，shutdown immediate;

3,startup mount;

4,alter system enable restricted session;

5,alter system set job_queue_processe=0;

6,alter system set aq_tm_processes=0;

7,alter database open;

8,alter database character set internal_use ZHS16GBK;

9,shutdown immediate;

10,startup;

select userenv('language') from dual;     查看字符集

sqlplus / as sysdba
SHUTDOWN IMMEDIATE; 
STARTUP MOUNT ; 
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET ZHS16GBK; (提示我们的字符集：新字符集必须为旧字符集的超集，这时我们可以跳过超集的检查做更改： )
ALTER DATABASE character set INTERNAL_USE ZHS16GBK;( 常见的Oracle字符集有ZHS16GBK、AL32UTF8、US7ASCII，UTF8等用途待查)
SHUTDOWN immediate;
startup;
select * from v$nls_parameters where parameter='NLS_CHARACTERSET';  查询数据库字符的名字