If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Can we create a snapshot log on a snapshot. If we create, Does the snapshot log that is created on a snapshot records all the changes made to the snapshot.

Ex: 1) I have a table A.

2) Create the snapshot log for A.

3) create a snapshot B for A.

4) Create the snapshot log for B.

5) Update a record in the table A.

6) Snapshot log for A is recorded the changes made to A.

7) Apply the FORCE Refresh on the snapshot B.

8) The snapshot B is updated with the modified data.

So, there is a change in the data on the snapshot B. But, there are no changes recorded in the snapshot log that is created for B.

so, I am interested in knowing, what the oracle says for this scenario. I am not able to find this information in the Oracle documentation. Can any body tell me, whether is it possible to record the changes that are made to snapshots like (B) in my example.