Oracle 字符集更改

sqlplus sys/player as sysdba

SQL*Plus: Release 11.2.0.1.0 Production

shutdown immediate;
startup mount;
alter system enable restricted session;
show parameter job_queue_processes;
show parameter aq_tm_processes;
alter system set job_queue_processes=0;
alter system set aq_tm_processes=0;

alter database open;
alter database character set ZHS16GBK;
--alter database character set internal_use ZHS16GBK;  --跳过超子集检测
select * from nls_database_parameters where parameteR='NLS_CHARACTERSET';

shutdown immediate;
startup mount;
alter system set job_queue_processes=X;
alter system set aq_tm_processes=X;
alter database open;

 

Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator>sqlplus sys/player as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期三 7月 26 15:59:41 2017

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             243271080 bytes
Database Buffers          528482304 bytes
Redo Buffers                5259264 bytes
数据库装载完毕。
SQL> alter system enable restricted session;

系统已更改。

SQL> show parameter job_queue_processes;

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
job_queue_processes                  integer
1000
SQL> show parameter aq_tm_processes;

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
aq_tm_processes                      integer
0
SQL> alter system set job_queue_processes=0;

系统已更改。

SQL> alter database open;

数据库已更改。

SQL> alter database character set ZHS16GBK;
alter database character set ZHS16GBK
*
第 1 行出现错误:
ORA-12712: 新字符集必须为旧字符集的超集


SQL> alter database character set internal_use ZHS16GBK;

数据库已更改。

SQL> select * from nls_database_parameters where parameteR='NLS_CHARACTERSET';

PARAMETER
------------------------------
VALUE
-------------------------------------------------------------------------------

NLS_CHARACTERSET
ZHS16GBK


SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount;
ORACLE 例程已经启动。

Total System Global Area  778387456 bytes
Fixed Size                  1374808 bytes
Variable Size             243271080 bytes
Database Buffers          528482304 bytes
Redo Buffers                5259264 bytes
数据库装载完毕。
SQL> alter system set job_queue_processes=1000;

系统已更改。

SQL> alter database open;

数据库已更改。