Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to modify the character set of a single instance of oracle11g. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

SQL > conn / as sysdba

SQL > select * from nls_database_parameters where parameter='NLS_CHARACTERSET'

PARAMETER

-

VALUE

NLS_CHARACTERSET

AL32UTF8

SQL > shu immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup mount

ORACLE instance started.

Total System Global Area 6.2934E+10 bytes

Fixed Size 2268712 bytes

Variable Size 6039798232 bytes

Database Buffers 5.6774E+10 bytes

Redo Buffers 118157312 bytes

Database mounted.

SQL > alter system enable restricted session

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 > shu immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL > startup

ORACLE instance started.

Total System Global Area 6.2934E+10 bytes

Fixed Size 2268712 bytes

Variable Size 6039798232 bytes

Database Buffers 5.6774E+10 bytes

Redo Buffers 118157312 bytes

Database mounted.

Database opened.

SQL > select * from nls_database_parameters where parameter='NLS_CHARACTERSET'

PARAMETER

-

VALUE

NLS_CHARACTERSET

ZHS16GBK

This is the end of the article on "how to modify the character set of a single instance of oracle11g". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.