oracle编码修改


		oracle编码修改
 
SQL> shutdown immediate; 
Database closed.   www.zzzyk.com  
Database dismounted. 
ORACLE instance shut down. 
SQL>  startup mount; 
ORACLE instance started. 
 
Total System Global Area  849530880 bytes 
Fixed Size                  1339824 bytes 
Variable Size             499125840 bytes 
Database Buffers          343932928 bytes 
Redo Buffers                5132288 bytes 
Database mounted. 
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> shutdown immediate; 
Database closed. 
Database dismounted. 
ORACLE instance shut down. 
 
select userenv('language') from dual ---查看编码 
 
oraacle clinet  编码设置 
 
打开注册表HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1 
将NLS_LANG 修改为 
select userenv('language') from dual  查询的值