熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

修改oracle10g的字符集

2013-11-13 15:28:26  來源: Oracle 

  修改數據庫字符集為ZHSGBK

  查看服務器端字符集

  SQL > select * from V$NLS_PARAMETERS;

  修改

  $sqlplus /nolog

  SQL>conn / as sysdba

  若此時數據庫服務器已啟動則先執行 SHUTDOWN IMMEDIATE 命

  令關閉數據庫服務器然後執行以下命令:

  SQL>shutdown immediate

  SQL>STARTUP MOUNT

  SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;

  SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=;

  SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=;

  SQL>ALTER DATABASE OPEN;

  SQL>ALTER DATABASE CHARACTER SET ZHSGBK

  *

  ERROR at line :

  ORA: operation cannot execute when other sessions are active

  若出現上面的錯誤使用下面的辦法進行修改使用INTERNAL_USE可以跳過超集的檢查

  SQL>ALTER DATABASE CHARACTER SET INTERNAL_USE ZHSGBK;

  SQL>SHUTDOWN IMMEDIATE

  SQL>STARTUP


From:http://tw.wingwit.com/Article/program/Oracle/201311/16772.html
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.