具体的步骤如下:
SQL> shutdown immediate; #关闭数据库
SQL> startup mount
SQL> alter session set sql_trace=true;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter system set aq_tm_processes=0;
SQL> alter database open;
SQL> alter DATABASE character set INTERNAL_USE zhs16gbk; # 使用INTERNAL_USE可以跳过超集的检查,用以强制完成字符集一致化。
SQL> shutdown immediate;
SQL> STARTUP
SQL> select value from nls_database_parameters where parameter='NLS_CHARACTERSET';#检查语言集修改情况;