删除用户时有如下报错:
SQL> drop user res cascade; drop user reservation cascade * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 【ORA-00604:递归SQL级别1发生错误】 ORA-00069: cannot acquire lock -- table locks disabled for DEPARTM 【ORA-00069:无法获取锁--已为DEPARTM禁用表锁】
解决办法:
alter table 表名 enable table lock;
alter table DEPARTM enable table lock;执行后解锁后即可删除用户了