之前在linux enterprise 5.4上安装了oracle 10g,因为字符集的缘故,用pl/sql developer 的时候老是报莫名其妙的错误,在网上查了一些资料,更改过来便修正了此问题,具体方法如下:
sqlplus / as sysdba;
shutdown immediate;
startup mount;
alter system enable restricted session;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;
alter database character set ZHS16GBK;
报错:error:must be a superset of old character set…..
alter database character set INTERNAL_USE ZHS16GBK;
select * from v$NLS_PARAMETERS;
此时发现客户端字符集已经更改成功。