Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to get date of last table change (DML) ?
In Oracle 7.3.3 and 8 I would like to know when a table was last changed due
to an insert, update or delete. I know about last_ddl_time, but I can not
find an equivalent for the last DML time.
Is it avaliable somewhere? Or do I need a trigger, or enable audit trails, to keep track of that?
Thanks,
Arjan.
Received on Wed Jul 15 1998 - 15:01:30 CDT
![]() |
![]() |