Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Last Table Access Timestamp
jredner_at_gmail.com wrote:
> I could have sworn there was a feature internal to Oracle that tagged
> a last access timestamp. I'm not talking about a column in the table
> itself, but something in Oracle's system tables or something.
>
> Does anyone know if this ever was/is a feature, and if so, how to
> access it?
If you mean insert/update/merge then check ora_rowscn with table
created with rowdependencies. Actually AFAIK it is just like
additional column, only Oracle itself maintains it :)
Gints Plivna
http://www.gplivna.eu
Received on Mon May 14 2007 - 16:17:34 CDT
![]() |
![]() |