OraFAQ Forum: Streams & AQ » Issues in dropping an Apply process

Home » Server Options » Streams & AQ » Issues in dropping an Apply process

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Issues in dropping an Apply process [message #262591]

Mon, 27 August 2007 12:28

toshidas2000
Messages: 120
Registered: November 2005

Senior Member

I am encountering following when tring to drop an apply process..

SQL> begin
DBMS_APPLY_ADM.DROP_APPLY(
apply_name => 'apply_simp');
end; 2 3 4
5 /
begin
*
ERROR at line 1:
ORA-24026: operation failed, queue STRMADMIN.STRM01_QUEUE has errors
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 87
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 603
ORA-06512: at line 2

Report message to a moderator

Re: Issues in dropping an Apply process [message #262732 is a reply to message #262591]

Tue, 28 August 2007 03:03

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Hai use this one,

BEGIN
DBMS_APPLY_ADM.DROP_APPLY(
apply_name => 'apply_simp',
drop_unused_rule_sets => true);
END;
/

[Updated on: Tue, 28 August 2007 03:03]

Report message to a moderator

Re: Issues in dropping an Apply process [message #262733 is a reply to message #262591]

Tue, 28 August 2007 03:05

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

If you have still errors while dropping and it shows message apply process must be empty then before doing drop empty apply process by

BEGIN
DBMS_APPLY_ADM.DELETE_ALL_ERRORS(
  apply_name  => 'apply_simp' );
END;

Report message to a moderator

Previous Topic:	Capture Process to Java JMS problem
Next Topic:	Oracle Stream in same schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 11 17:34:16 CST 2024