Home » Server Options » Streams & AQ » Issues in dropping an Apply process
Issues in dropping an Apply process [message #262591] Mon, 27 August 2007 12:28 Go to next message
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
Re: Issues in dropping an Apply process [message #262732 is a reply to message #262591] Tue, 28 August 2007 03:03 Go to previous messageGo to next message
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 Go to previous message
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;

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


Current Time: Fri Mar 29 06:34:49 CDT 2024