How do I find the date on a snapshot table?

[dbawannab]

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)

[pando]

try dba_snapshots

[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?

[aarroyob]

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