Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: Monitoring Replication Errors

    Hi,

    I want to know which file (or files) Oracle uses to report an error ocurred during a replication process. Also Iīd like to know the directory where these files usually are.

    Thanks in advance,

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Replication errors are in the deferror queue. You can use the info
    in the deferror and defcall table to piece together the problems



    col callno heading "Call|No" format 999999
    col deferred_tran_id heading "Deferred|Tran|ID" format a12
    col schemaname heading "Schema|Name" format a8
    col packagename heading "Package|Name" format a25
    col procname heading "Procedure|Name" format a10
    col argcount heading "Arg|Count" format 999
    col origin_tran_db heading "Origin" format a17

    SELECT c.callno,
    c.deferred_tran_id,
    c.packagename,
    c.procname,
    c.argcount,
    e.origin_tran_db
    FROM defcall c, deferror e
    WHERE c.deferred_tran_id = e.deferred_tran_id
    AND c.callno = e.callno
    ORDER BY e.start_time
    /


    Hth

    Gregg

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •