在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 utf8;(如提示新字符集必须为旧字符集的超集,
则改用alter database character set internal_use utf8;)
shutdown immediate;
startup; (重开正常oracle)
注意,以上命令必须在sql plus中执行,不能再sql/server中执行,在sql/server中执行上述命令会提示:
ORA-00900: 无效 SQL 语句
pl/sql不具备支持如此命令!