对已经建好的数据库更改字符集:(这里改成utf8)
Oracle用户下:
connect system/oracle10g as sysdba;
update props$ set value$=’UTF8′ where name=’NLS_CHARACTERSET’;
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 open;
alter database character set internal_use UTF8;
alter database national character set internal_use UTF8;
shutdown immediate;
startup;
Oracle用户下:
connect system/oracle10g as sysdba;
update props$ set value$=’UTF8′ where name=’NLS_CHARACTERSET’;
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 open;
alter database character set internal_use UTF8;
alter database national character set internal_use UTF8;
shutdown immediate;
startup;