How do I find the date on a snapshot table?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How do I find the date on a snapshot table?

  1. #1
    Join Date
    Apr 2000
    Location
    arlington, va USA
    Posts
    24
    I am trying to find the last date and time that a snapshot updates to a table. How do I find that information?
    What I want to do is create a trigger that runs after the table has been updated. I'm looking for a date/time field that the snapshot creates, any information will help.

    tia

    (thanks in advance)
    DBAWannaB

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    try dba_snapshots

  3. #3
    Join Date
    Apr 2000
    Location
    arlington, va USA
    Posts
    24
    Pando,
    will that tell me when the table was last updated? What new entries were put into the table?
    I'm lookign for a date/time on the table
    that can be queried to run a trigger against. Are you saying that I should try to run
    the trigger after the snapshot?
    DBAWannaB

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi,

    The only one will show you the information is ALL_SNAPSHOT_REFRESH_TIMES. The other related tables always show the same date:01/01/50

    This will help you

    Regards

    Angel

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