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