Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Snapshot's Last refresh
try USER_SNAPSHOT_REFRESH_TIMES
or ALL_SNAPSHOT_REFRESH_TIMES
..
zijlr_at_yahoo.com (Ron van Zijl) wrote in message news:<89bdbf34.0203031256.b0638a9_at_posting.google.com>...
> I have noticed the same. Even if you perform a FULL REFRESH it does
> not update the last refresh date. Might be a bug in Oracle. I have
> noticed it in all 8i's up to 8.1.7.3.0.
>
> Ron
> "Matthieu DEGLIN" <mdeglin_at_remove-me.partner.auchan.com> wrote in message news:<a3m8eg$2od$1_at_reader1.imaginet.fr>...
> > Hello,
> >
> > Although my snapshots correctly work, the LAST_REFRESH column of
> > USER_SNAPSHOTS remain empty...
> >
> > Any explanation ?
> >
> > Thanks.
> >
> > Matthieu DEGLIN
Received on Mon Mar 04 2002 - 18:08:13 CST