修改为utf8:
connect system 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 open ;
alter database character set internal_use UTF8;
shutdown immediate ;
startup ;
修改'NLS_LENGTH_SEMANTICS'为CHAR
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR scope=BOTH;
shutdown immediate ;
startup ;
connect system 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 open ;
alter database character set internal_use UTF8;
shutdown immediate ;
startup ;
修改'NLS_LENGTH_SEMANTICS'为CHAR
ALTER SYSTEM SET NLS_LENGTH_SEMANTICS=CHAR scope=BOTH;
shutdown immediate ;
startup ;