oracle字符集安装时选择了西文,想改成中文?

oracle字符集安装时选择了西文,想改成中文?
不重装oracle,

解决方案 »

  1.   

    1、检查服务器上Oracle数据库的字符集   
        
      SQL>   conn   sys/change_on_install   
      连接成功.   
        
      SQL>   desc   props$   
        列名                                                     可空值否       类型   
        -------------------------------   --------   ----   
        NAME                                                         NOT   NULL   VARCHAR2(30)   
        VALUE$                                                                       VARCHAR2(2000)   
        COMMENT$                                                                   VARCHAR2(2000)   
        
      SQL>   col   value$   format   a40   
      SQL>   select   name,value$   from   props$;   
        
      NAME                                                       VALUE$   
      ------------------------------   -------------------------   
      DICT.BASE                                             2   
      NLS_LANGUAGE                                       AMERICAN   
      NLS_TERRITORY                                     AMERICA   
      NLS_CURRENCY                                       $   
      NLS_ISO_CURRENCY                               AMERICA   
      NLS_NUMERIC_CHARACTERS                   .,   
      NLS_DATE_FORMAT                                 DD-MON-YY   
      NLS_DATE_LANGUAGE                             AMERICAN   
      NLS_CHARACTERSET                               ZHS16GBK   
      NLS_SORT                                               BINARY   
      NLS_CALENDAR                                       GREGORIAN   
      NLS_RDBMS_VERSION                             7.3.4.0.0   
      GLOBAL_DB_NAME                                   ORACLE.WORLD   
      EXPORT_VIEWS_VERSION                       3   
        
        
        
      NLS_CHARACTERSET和NLS_CHAR_CTERSET这个参数应该是ZHS16GBK，如不是，改为它。   
        
      SQL*Plus中修改方法：   
      SQL>   update   props$   set   value$='新字符集'   where   name='NLS_CHARACTERSET';   
      

  2.   

    開始--運行--輸入regedit--HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient10g_home1\修改NLS_LANG,到網上查一下就OK了
      

  3.   

    http://publish.it168.com/2006/0221/20060221236101.shtml