-
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
-
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|