oracal数据库中表jd_jl_blatoconv中的数据我用delete from jd_jl_blatoconv t删除,显示正在执行,里面有1万4千条数据,但是过了7分钟还是在执行,取消之后再查数据还在,根据网上说的我又用purge table jd_jl_blatoconv,系统说没在回收站;又用drop table jd_jl_blatoconv purge,系统说‘ORA-00054:资源正忙,但指定以NOWAIT方式获取资源’,我已经重启机了,问题还在,请问高手如何应对??
调试欢乐多
或者重启电脑,以restrict方式启动,删除后再取消restrict限制.
Typically, all users with the CREATE SESSION system privilege can connect to an open database. Opening a database in restricted mode allows database access only to users with both the CREATE SESSION and RESTRICTED SESSION system privilege. Only database administrators should have the RESTRICTED SESSION system privilege. Further, when the instance is in restricted mode, a database administrator cannot access the instance remotely through an Oracle Net listener, but can only access the instance locally from the machine that the instance is running on.The following command starts an instance (and mounts and opens the database) in restricted mode:STARTUP RESTRICTYou can use the RESTRICT clause in combination with the MOUNT, NOMOUNT, and OPEN clauses.Later, use the ALTER SYSTEM statement to disable the RESTRICTED SESSION feature:ALTER SYSTEM DISABLE RESTRICTED SESSION;
sqlplus / as sysdba
shutdown abort
startup restrict
从这我该写啥??
或者说我前面哪错了?
SQL>sqlplus / as sysdba shutdown abort startup restrict这样??应该不是吧...
速度要快很多