DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to alter propagation SCHEDULE

  1. #1
    Join Date
    Aug 2006
    Posts
    26

    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:

  2. #2
    Join Date
    Aug 2006
    Posts
    26
    have anyone found the problem?

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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.

  4. #4
    Join Date
    Aug 2006
    Posts
    26
    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
  •  


Click Here to Expand Forum to Full Width