Erro do dropar o usuario ORAESB

SQL> drop user oraesb cascade;
drop user oraesb cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-24170: ORAESB.ESB_MONITOR_N is created by AQ, cannot be dropped directly
ORA-06512: at "SYS.DBMS_RULE_ADM", line 158
ORA-06512: at line 1

1.Set the following event at session level:
alter session set events '25475 trace name context forever, level 2';

2. Drop rule:
execute DBMS_RULE_ADM.DROP_RULE('.AQ$WF_DEFERRED_QUEUE_M$1',TRUE);
commit;

3.Drop rule set:
execute DBMS_RULE_ADM.DROP_RULE_SET('AQ$WF_DEFERRED_QUEUE_M$1');
commit;

4. Connect as SYSTEM or SYSDBA and try to drop user again.
drop user <user> cascade;

Comentários