oracle字符集修改

oracle字符集修改

查询当前字符集

select userenv('language') from dual;

修改字符集

Server端字符集修改
将数据库启动到RESTRICTED模式下做字符集更改：
$ sqlplus "/as sysdba"
SQL> conn /as sysdba;
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 UTF8;-- SET ZHS16GBK
SQL> shutdown immediate;
SQL> startup;
SQL> exit;