先停止服务,再修修改字符集
SQL> alter session set sql_trace=true;
Session altered.
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 JA16SJIS;
Database altered.
可以尝试一下下面的方法:
一、在SQL*PLUS 中,以DBA登录
conn 用户名 as sysdba
二、然后执行以下命令
>shutdown immediate; (把database停了)
>startup mount; (把database重开去可更改情況)
>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 CHINESE_CHINA.ZHS16GBK;
>shutdown immediate;
>startup; (重开正常oracle)