Can we have a Snapshot log for a Snapshot insted of a Table
DBAsupport.com 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
    Location
    Chennai
    Posts
    27
    Hi,

    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.

    --Srinivas.


    Share on Google+

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    trying updating any record in snapshot B and see if the changes are noticed in snapshot log B

    regards
    anandkl
    anandkl
    Share on Google+

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    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