Oracle 11g 更换字符集

cg_ssh

于 2024-09-15 09:25:35 发布

阅读量79

点赞数

文章标签：服务器

本文链接：https://blog.csdn.net/cg_ssh/article/details/142279940

版权

C:\Users\admin>sqlplus sys/sys@orcl as sysdba;

SQL*Plus: Release 11.2.0.4.0 Production on Sun Sep 15 09:18:10 2024

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 5044088832 bytes
Fixed Size                  2289920 bytes
Variable Size            1006636800 bytes
Database Buffers         4026531840 bytes
Redo Buffers                8630272 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 zhs16gbk;
alter database character set zhs16gbk
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set


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 5044088832 bytes
Fixed Size                  2289920 bytes
Variable Size            1006636800 bytes
Database Buffers         4026531840 bytes
Redo Buffers                8630272 bytes
Database mounted.
Database opened.
SQL>