Modifying the character set of Oracle 10g express Edition

Oracle 10g express edition is a free version dedicated to small users. Oracle Xe is very small and easy to install and can be used by third-party software developers to deploy small applications.
However, Oracle Xe's current beta2 default installation character set is we8mswin1252, not a Chinese character set, and cannot be directly run through
Alter database character set zhs16gbk;
Because zhs16gbk is not the superset of the default character set.
In the past, the widely spread method of directly modifying the props $ table under sys users also leaves many potential problems for character set changes.

However, after installing Oracle XE, you can modify the character set in sqlplus (Oracle Xe's run SQL command line) by performing the following operations:

Connect system/Oracle9i as sysdba

Shutdown immediate

Startup Mount

Alter system enable restricted session;

Alter system set job_queue_processes = 0;

Alter system set aq_tm_processes = 0;

Alter database open;

Alter database character set internal_use zhs16gbk;

Shutdown immediate

Startup

This completes the modification of the character set.

Inspirational quotes Ji Feng blog