| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|  |  | |||
Home -> Community -> Usenet -> c.d.o.server -> Snapshot Replication question
Reply to: Jim_Wartnick_at_cargill.com
>
>        In simple snapshot replication (fast refreshes), is there a way
 to
>      determine which sites have not had the logs applied to them yet?
 This
>
>      is not too difficult if the snapshots are local. However, if the
>      snapshot is in a different database, this becomes more difficult.
 The
>
>      only view with information (that I am aware of) is
>      SYS.DBA_SNAPSHOT_LOGS, which is built off of SYS.MLOG$ AND
 SYS.SLOG$.
>
>      I have not found another table, or for that case, another way, to
 
> view
>      which transactions have been applied to which snapshot sites.
>
>      If you know the answer, or know someone who knows the answer,
 could
>      you let me know. It is one of those things that is bugging me
 like
> the
>      TEMP owner scripts. The manuals do not specify how to do this,
 what I
>
>      would consider essential, trick.
>
>      -Jim Wartnick
Received on Sat Mar 14 1998 - 00:00:00 CST
|  |  |