Re: replication's tables and

Hello!

  Thanks but It's not exactly what I'm looking for. I need to get full SQL-query's text has been executed on master site. Looking at that SQL-query I can define why this SQL failed replicate (e.g. due to different table definition or smth like)

Rgds, Vadim Grepan

bgbgbg wrote:

> 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 Thu Nov 23 2000 - 12:44:21 CST