-
how to alter propagation SCHEDULE
the following is my alter procedure,but it display ORA-24042 error,how to resolve the problem?
1.create propagation rule
Begin
Dbms_Streams_Adm.Add_Table_Propagation_Rules(
Table_Name => 'zltools.zlsystems',
Streams_Name => 'p_zltools',
Source_Queue_Name => 'strmadm.q_zlhis',
Destination_Queue_Name => 'strmadm.q_zlhis@ORC0.net',
Include_Dml => True,
Include_Ddl => True,
Source_Database => 'ORC1.net');
End;
it is success.
2.alter the time of propagation job
BEGIN
DBMS_AQADM.ALTER_PROPAGATION_SCHEDULE(
queue_name => 'q_zlhis',
destination => 'orc0.net',
duration => 300,
next_time => 'SYSDATE + 1200/86400',
latency => 25,
destination_queue => 'q_zlhis');
END;
but it display ora-24042 when i execute above sql:
-
have anyone found the problem?
-
ORA-24042: no propagation schedule exists for QUEUE string and DESTINATION string
Cause: AN UNSCHEDULE_PROPAGATION was issued for a queue and destination pair which has no existing propagation schedule.
Action: Verify the spelling of the specified QUEUE and DESTINATION and then reissue the call with the correct spelling.
-
dont the procedure Dbms_Streams_Adm.Add_Table_Propagation_Rules create the propagation schedule for QUEUE ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|