1.(Window:)cmd下輸入set ORACLE_SID=你想進(jìn)入的數(shù)據(jù)庫的那個(gè)sid

創(chuàng)新互聯(lián)建站專注于鳳慶網(wǎng)站建設(shè)服務(wù)及定制,我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗(yàn)。 熱誠為您提供鳳慶營銷型網(wǎng)站建設(shè),鳳慶網(wǎng)站制作、鳳慶網(wǎng)頁設(shè)計(jì)、鳳慶網(wǎng)站官網(wǎng)定制、重慶小程序開發(fā)服務(wù),打造鳳慶網(wǎng)絡(luò)公司原創(chuàng)品牌,更為您提供鳳慶網(wǎng)站排名全網(wǎng)營銷落地服務(wù)。
(Linux:)切換到oracle用戶:export ORACLE_SID=你想進(jìn)入的數(shù)據(jù)庫的那個(gè)sid
2.輸入 sqlplus /nolog
3.將數(shù)據(jù)庫啟動(dòng)到RESTRICTED模式下做字符集更改:
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 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 ZHS16GBK;
--修改為英文字符集
SQL> ALTER DATABASE character set INTERNAL_USE AL32UTF8;
Database altered.
SQL> select * from v$nls_parameters;
略
19 rows selected.
重啟檢查是否更改完成:
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> select * from v$nls_parameters;
文章題目:Oracle修改數(shù)據(jù)庫字符集
網(wǎng)站路徑:http://chinadenli.net/article16/pgjdgg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供、企業(yè)網(wǎng)站制作、定制開發(fā)、網(wǎng)站制作、定制網(wǎng)站、關(guān)鍵詞優(yōu)化
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時(shí)需注明來源: 創(chuàng)新互聯(lián)