删除用户 ---ORA-04098

SQL> drop user test cascade;
drop user test cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-04098: trigger 'TEST.AW_DROP_TRG' is invalid and failed re-validation

sysdba登录查看这个参数配置: _system_trig_enabled为enable, 需要设置为false. 8i and 9i有不同的设置方法

SQL> select KSPPITY,KSPPDESC,INST_ID from x$ksppi where ksppinm='_system_trig_enabled';

   KSPPITY KSPPDESC                                                            INST_ID
---------- ---------------------------------------------------------------- ----------
         1 are system triggers enabled                                               1

9i:

SQL> ALTER SYSTEM SET "_system_trig_enabled"=FALSE;

System altered.

SQL> drop user test cascade;

User dropped.

Once the required steps are complete you can reenable triggers thus:

 

http://blog.oracle.com.cn/html/27/166427-4836.html

转载于:https://www.cnblogs.com/yuking/archive/2013/05/19/3086891.html