数据库原有字符集为:“UTF-8”,修改为:“GBK”
修改前:
select * from nls_database_parameters;
select userenv('language') from dual;
修改步骤
1.关闭数据库
shutdown immediate;
2.mount数据库
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
3.修改字符集为GBK
ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;
4.重启数据库
SHUTDOWN IMMEDIATE;
STARTUP;
查看修改后的字符集
select * from nls_database_parameters;
select userenv('language') from dual;