今天安装数据库,自作聪明的把数据把数据库编码改为了AL32UTF8,结果打开PLsql developer 就报错了,上网上看了看资料,进行如下操作就OK了
cmd中进行如下操作
SQL> sqlplus sys/sys as sysdba;(sys /as sysdba)
SQL> shutdown immediate;SQL> startup mount;
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;
SQL> shutdown immediate;
SQL> startup;