Can we have a Snapshot log for a Snapshot insted of a Table Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Can we have a Snapshot log for a Snapshot insted of a Table

  1. #1
    Join Date
    Apr 2002

    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.


    Share on Google+

  2. #2
    Join Date
    Aug 2001
    trying updating any record in snapshot B and see if the changes are noticed in snapshot log B

    Share on Google+

  3. #3
    Join Date
    Nov 2000
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width