更改Oracle字符集：把字符集ZHS16GBK换成UTF8

SQL> shutdown immediate

Database closed. Database dismounted. ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started. Total System Global Area 1845493760 bytes Fixed Size 2021568 bytes Variable Size 452986688 bytes Database Buffers 1375731712 bytes Redo Buffers 14753792 bytes Database mounted.

SQL> alter session set sql_trace=true;

Session altered.

SQL> alter system enable restricted session;

System altered.

SQL> alter system set job_queue_processes=0;

System altered.

SQL> alter system set aq_tm_processes=0;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database character set INTERNAL_USE UTF8;

Database altered.

SQL>update props setVALUE =’UTF8’ where NAME=’NLS_NCHAR_CHARACTERSET’

反正就是玩，玩会重装。。不过还行，能用