本文共 431 字,大约阅读时间需要 1 分钟。
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;
OR
>alter database character set internal_use utf8;
>shutdown immediate;
>startup; (重开正常oracle)
Windows下查找/bin/sqlplus.exe
Linux进入sqlplus / as sysdba
参考网址:
转载地址:http://lmapi.baihongyu.com/