Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Last table access time?
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