> 

查看服务器端字符集

select userenv('language') from dual;

修改字符集

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

 

 

来源：

<wiz_tmp_tag id="wiz-table-range-border" contenteditable="false" style="display: none;">