Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Last Table Access Timestamp

Re: Last Table Access Timestamp

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 14 May 2007 14:17:34 -0700
Message-ID: <1179177454.113572.113050@p77g2000hsh.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US