Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Identifying failed snapshots ?
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
![]() |
![]() |