修改oracle的字符集

 

1、查看数据库语言设置

select * from NLS_DATABASE_PARAMETER;    

select userenv('language') from dual;

 

2、修改字符集

SQL>SHUTDOWN IMMEDIATE

 

SQL>STARTUP MOUNT;

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 INTERNAL_USE ZHS16GBK;

 

SQL>ALTER DATABASE NATIONAL CHARACTER SET ZHS16GBK; 

SQL>SHUTDOWN IMMEDIATE;

SQL>STARTUP