Modify the oracle 10g Character Set and oracle10 g Character Set

Modify the oracle 10g Character Set and oracle10 g Character Set

Modify the character set of oracle 10 GB

Modify the database character set to ZHS16GBK.
View server character sets

SQL> select * from V $ NLS_PARAMETERS; Modify: $ sqlplus/nologSQL> conn/as sysdba. If the database server has been started, run the SHUTDOWN IMMEDIATE command to shut down the database server, run the following command: SQL> shutdown immediateSQL> startup mountsql> 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 ZHS16GBK * ERROR at line 1: ORA-12721: operation cannot execute when other sessions are active if the above ERROR occurs, use the following method to modify the data. Use INTERNAL_USE to skip the superset check: SQL> alter database character set INTERNAL_USE ZHS16GBK; SQL> SHUTDOWN IMMEDIATESQL> STARTUP