Re: replication's tables and

From: bgbgbg <brian.gallagher_at_iona.com>
Date: Wed, 22 Nov 2000 12:30:39 -0000
Message-ID: <8vgeo5$irv$1@bvweb.iona.com>

if you want to see deftran:

SELECT deferred_tran_id,

        delivery_order,
        destination_list,
        start_time

FROM deftran
ORDER BY start_time
/

if u want to see defcall:

SELECT  c.callno,
        c.deferred_tran_id,
        c.packagename,
        c.procname,
        c.argcount,
        d.dblink

FROM defcall c, defcalldest d
WHERE c.callno = d.callno
AND c.deferred_tran_id = d.deferred_tran_id /

deferror:
SELECT deferred_tran_id,

        deferred_tran_db,
        destination,
        error_number

FROM deferror
/

"Vadim Grepan" <kezal_at_mail.ru> wrote in message news:3A1B806A.3751F8CB_at_mail.ru...
> Hello!
>
> I've tired to fight with OracleReplicationManager so I wrote some
> PL/SQL procedures
> to view various replication-related info. Unfortunatly I cannot find
> any view or tables keeping deferred transaction's SQL clauses. All DEF*
> views I've reviewed.
> Does anybody work with it?
>
> Rgds, Vadim Grepan
> ------------------------------------
> Moscow, Russia
> email: kezal(_at_)mail.ru
>
Received on Wed Nov 22 2000 - 06:30:39 CST