ALL_SNAPSHOT_REFRESH_TIMES (or USER_), i believe shows the correct date/time.
papakee_at_aol.com (Tim McKee) wrote in message news:<b3473ba.0111290723.3b15a220_at_posting.google.com>...
> I keep getting a refresh date of 01-Jan-1950 in the last_refresh field
> in dba_snapshots on Oracle 8i. My snapshots are refreshing correctly
> both manually and on schedule, but the date does not change. I've
> seen this problem reported several times in the past and was wondering
> if anyone as found the solution. My planned use of this field is
> relay the last time a snapshot was refreshed on forms and reports.
> All help is greatly appreciated.
>
> -Tim
Received on Thu Nov 29 2001 - 14:33:24 CST
