Propagation Schedule Stuck in Pending State
OID NAME
--------------------------------
------------------------------
E6D2893064F308B7E0340003BA68067D NY3_QUEUE
Then update the PENDING status to N as
shown below:
SQL> update aq$_schedules set DISABLED =
'N'
SEE
CODE DEPOT FOR FULL SCRIPT
1 row updated.
SQL> commit ;
Commit complete.
SQL> alter system set
job_queue_processes = 6;
System altered.
-- Then remove the Configuration, it
works...
DNYTST10 SQL>EXEC
DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
PL/SQL procedure successfully completed.
