查詢字符集
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.文章來(lái)源：http://www.zghlxwxcb.cn/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.文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-666247.html
select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
到了這里，關(guān)于Oracle修改字符集為SIMPLIFIED CHINESE_CHINA.ZHS16GBK的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
