Propagation Schedule Stuck in Pending State
BEGIN
DBMS_PROPAGATION_ADM.DROP_PROPAGATION(
propagation_name => 'ny3_propagate',
drop_unused_rule_sets => true);
END;
/
BEGIN
*
ERROR at line 1:
ORA-24080: unschedule_propagation pending
for QUEUE STRMADM.NY3_QUEUE and
DESTINATION DNYOIP20.WORLD
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line
1186
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line
1074
ORA-06512: at "SYS.DBMS_PROPAGATION_ADM",
line 110
ORA-06512: at line 2
Resolution: First make queue processes
zero, then find the OID value from
aq$_queues table.
SQL> alter system set
job_queue_processes = 0 ;
System altered.
SQL> select oid, name from
system.aq$_queues where name = 'NY3_QUEUE' ;
