Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Snapshot Replication question

Snapshot Replication question

From: Brian Motzer <bmotzer_at_spacestar.net>
Date: 1998/03/14
Message-ID: <350AE0F4.18377D02@spacestar.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US