查询字符集
select userenv('language') from dual;
修改前字符集为：SIMPLIFIED CHINESE_CHINA.AL32UTF8
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 5027385344 bytes
Fixed Size 2261888 bytes
Variable Size 1006636160 bytes
Database Buffers 4009754624 bytes
Redo Buffers 8732672 bytes
Database mounted.
SQL> alter system enable restricted session;
System altered.
SQL> alter system set JOB_QUEUE_PROCESSES=0;
System altered.
SQL> alter system set AQ_TM_PROCESSES=0;
System altered.
SQL> alter database open;
Database altered.
SQL> alter database character set internal_use ZHS16GBK;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.文章来源：https://www.toymoban.com/news/detail-666247.html
Total System Global Area 5027385344 bytes
Fixed Size 2261888 bytes
Variable Size 1006636160 bytes
Database Buffers 4009754624 bytes
Redo Buffers 8732672 bytes
Database mounted.
Database opened.文章来源地址https://www.toymoban.com/news/detail-666247.html
select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
到了这里，关于Oracle修改字符集为SIMPLIFIED CHINESE_CHINA.ZHS16GBK的文章就介绍完了。如果您还想了解更多内容，请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章，希望大家以后多多支持TOY模板网！
