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

Home -> Community -> Mailing Lists -> Oracle-L -> Identifying failed snapshots ?

Identifying failed snapshots ?

From: Ken Friday <ken.friday_at_TELDTA.COM>
Date: Thu, 28 Dec 1995 11:16:08 -0600
Message-Id: <9512281743.AA07986@alice.jcc.com>

     Hello,

     I have a master table with an associated snapshot log. There are
     multiple (simple) snapshots defined against this master.

     What is the easiest way to identify those snapshots that have NOT
     successfully used the   log (rows within) ? At this point I don't care
     why, it could be a failure of scheduling issue.

     Oracle's documentation states that the rows in the log are NOT deleted
     until ALL the snapshots have used them. This implies that the "master"
     knows which shnpshots are "interested" in the data and their status.
     Is this information available to me ?

     Thank you (in advance)
     Ken F.

Received on Thu Dec 28 1995 - 12:43:23 CST

Original text of this message

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