删除用户 ---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:
