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

Re: Last table access time?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Fri, 23 Apr 1999 16:50:23 +0200
Message-ID: <7fq1b3$3om$1@weber.a2000.nl>


stevegreer wrote
> If you have not been using auditing or custom triggers of some kind, is
there
> a way to determine when a table was last accessed for any reason - DDL or
> DML?
DML: no;
DDL (including grants and revokes): yes; column last_ddl_time in all_objects.

Arjan. Received on Fri Apr 23 1999 - 09:50:23 CDT

Original text of this message

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