oracle基礎教程（8）oracle修改字元集

標籤：

oracle基礎教程（8）oracle修改字元集

 

1、用dba串連資料庫

-->sqlplus / as sysdba

2、查看字元集 

-->SELECT parameter, value FROM v$nls_parameters WHERE parameter LIKE ‘%CHARACTERSET‘;

好像結果：

PARAMETER----------------------------------------------------------------VALUE----------------------------------------------------------------NLS_CHARACTERSETZHS16GBKNLS_NCHAR_CHARACTERSETAL16UTF16

3、修改字元集

SQL> alter database character set INTERNAL_USE AL32UTF8;

 

4、具體命令執行過程：

C:\Users\Administrator>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on 星期日 7月 3 13:11:46 2016Copyright (c) 1982, 2010, Oracle.  All rights reserved.串連到:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>SQL>  SELECT parameter, value FROM v$nls_parameters WHERE parameter LIKE ‘%CHARACTERSET‘;PARAMETER----------------------------------------------------------------VALUE----------------------------------------------------------------NLS_CHARACTERSETZHS16GBKNLS_NCHAR_CHARACTERSETAL16UTF16SQL> shutdown immediate;資料庫已經關閉。已經卸載資料庫。ORACLE 常式已經關閉。SQL>SQL>SQL> startup mount;ORACLE 常式已經啟動。Total System Global Area  855982080 bytesFixed Size                  2180544 bytesVariable Size             528484928 bytesDatabase Buffers          322961408 bytesRedo Buffers                2355200 bytes資料庫裝載完畢。SQL>SQL> alter session set SQL_TRACE=TRUE;會話已更改。SQL> alter system enable RESTRICTED SESSION;系統已更改。SQL> alter system set JOB_QUEUE_PROCESSES=0;系統已更改。SQL> alter system set AQ_TM_PROCESSES=0;系統已更改。SQL> alter database open;資料庫已更改。SQL> alter database character set INTERNAL_USE AL32UTF8;資料庫已更改。SQL> alter session set SQL_TRACE=false;會話已更改。SQL> shutdown immediate;資料庫已經關閉。已經卸載資料庫。ORACLE 常式已經關閉。SQL> startup;ORACLE 常式已經啟動。Total System Global Area  855982080 bytesFixed Size                  2180544 bytesVariable Size             528484928 bytesDatabase Buffers          322961408 bytesRedo Buffers                2355200 bytes資料庫裝載完畢。資料庫已經開啟。SQL>  SELECT parameter, value FROM v$nls_parameters WHERE parameter LIKE ‘%CHARACTERSET‘;PARAMETER--------------------------------------------------------------------------------VALUE--------------------------------------------------------------------------------NLS_CHARACTERSETAL32UTF8NLS_NCHAR_CHARACTERSETAL16UTF16SQL>

 

oracle基礎教程（8）oracle修改字元集