以DBA身份进入SQLPLUSSQLsqlplussys/sysassysdba;……SQLshutdownimmediate;SQLstartupmount;SQLaltersystemenablerestrictedsession;SQLaltersystemsetjob_queue_processes=0;SQLaltersystemsetaq_tm_processes=0;SQLalterdatabaseopen;SQLalterdatabasecharactersetinternal_useAL32UTF8;(ZHS16GBK)SQLshutdownimmediate;SQLstartup;这样就可以讲ORACLE的字符集修改为UTF8,如果需要修改为GBK只需将alterdatabasecharactersetinternal_useAL32UTF8;(ZHS16GBK)这句最后的AL32UTF8修改为ZHS16GBK即可