SQL> shutdown immediate; SQL> startup mount; SQL> alter system enable restricted session; SQL> alter system set job_queue_processes=0; SQL> alter database open; SQL> alter database character set internal_use ZHS16GBK; SQL> shutdown immediate; SQL> startup SQL> alter system disable restricted session;
sqlplus "/ as sysdba" SQL> SHUTDOWN IMMEDIATE SQL> STARTUP MOUNT 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 NATIONAL CHARACTER SETINTERNAL_USE UTF8; SQL> SHUTDOWN IMMEDIATE SQL> STARTUP
SQL> shutdown immediate; SQL> startup mount; SQL> alter system enable restricted session; SQL> alter system set job_queue_processes=0; SQL> alter database open; SQL> alter database character set internal_use AL32UTF8; SQL> shutdown immediate; SQL> startup SQL> alter system disable restricted session;
例 34.1. Oracle 字符集切换实例
C:\Users\Administrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Mon Nov 30 17:01:10 2015
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 3423965184 bytes
Fixed Size 2180544 bytes
Variable Size 1879050816 bytes
Database Buffers 1526726656 bytes
Redo Buffers 16007168 bytes
Database mounted.
SQL> alter system enable restricted session;
System altered.
SQL> alter system set job_queue_processes=0;
System altered.
SQL> alter database open;
Database altered.
SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 3423965184 bytes
Fixed Size 2180544 bytes
Variable Size 1879050816 bytes
Database Buffers 1526726656 bytes
Redo Buffers 16007168 bytes
Database mounted.
Database opened.
SQL> alter system disable restricted session;
System altered.
SQL>
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK
SQL>
原文出处：Netkiller 系列 手札
本文作者：陈景峯
转载请与作者联系，同时请务必标明文章原始出处和作者信息及本声明。
