Modify server Character Set

Modify the server character set (not recommended)

Before Oracle 8, you can directly modify the data dictionary table props $ to change the Oracle Character Set of the database. However, after oracle8, at least three system tables record the information of the database character set. modifying only the props $ table is incomplete and may cause serious consequences. The correct modification method is as follows:

 

1. $ Sqlplus/nolog
2. SQL>Conn/As sysdba;

If the database server has been started, run the shutdown immediate command to shut down the database server, and then run the following command:

 

2. SQL>Startup Mount;
4. SQL>Alter system enable restricted session;
6. SQL>Alter system setJob_queue_processes=0;
8. SQL>Alter system setAq_tm_processes=0;
10. SQL>Alter database open;
12. SQL>Alter database character set zhs16gbk;
14. SQL>Alter database National Character Set zhs16gbk;
16. SQL>Shutdown immediate;
18. SQL>Startup

 

NOTE: If there are no large objects, there is no impact on language conversion during use (remember that the Oracle character set must be supported by Oracle, or you cannot start it, however, a message like 'ora-12717: cannot alter database national character set when nclob data exists' may appear.

There are two ways to solve this problem

One is to use the internal_use keyword to modify the region settings,

Another method is to use re-create, but re-create is a little complicated, so use internal_use,

 

2. SQL>Shutdown immediate;
4. SQL>Startup Mount exclusive;
6. SQL>Alter system enable restricted session;
8. SQL>Alter system setJob_queue_processes=0;
10. SQL>Alter system setAq_tm_processes=0;
12. SQL>Alter database open;
14. SQL>Alter database National Character Set internal_use utf8;
16. SQL>Shutdown immediate;
18. SQL>Startup;

 

If you follow the above steps, there will be no problem with the region settings of the National charset. The above content is the description of modifying the Oracle character set. I hope it will help you in this regard.