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.
(thanks in advance)
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?
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
Click Here to Expand Forum to Full Width