centos 安裝oracle 11g r2（四）-----修改字符集為ZHS16GBK
一、查詢兩個庫的字符集
select userenv('language') from dual;
源端：
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
目標(biāo)端：
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8
二份氧、修改目標(biāo)端字符集
SQL> alter system checkpoint;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1586708480 bytes
Fixed Size ? ? 2253624 bytes
Variable Size 1040190664 bytes
Database Buffers ? 536870912 bytes
Redo Buffers ? ? 7393280 bytes
Database mounted.
SQL>
SQL>
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 ZHS16GBK;
Database altered.
SQL> alter system set nls_language='AMERICAN' scope=spfile;
System altered.
SQL> alter system set nls_territory='AMERICA' scope=spfile;
System altered.
SQL> shutdown immediate;? ? ? ? ? ?
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 1586708480 bytes
Fixed Size ? ? 2253624 bytes
Variable Size 1040190664 bytes
Database Buffers ? 536870912 bytes
Redo Buffers ? ? 7393280 bytes
Database mounted.
Database opened.
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
————————————————
