How to get date of last table change (DML) ? 
Author Message
 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.



Sun, 31 Dec 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Q: Getting The Date/Time Of The Last Mod Of A Sql svr Table

2. How to get date last changed for table?

3. Date of last table change

4. Manipulating Dates - getting last day of month

5. Last Synchonization date not getting updated...

6. Where is last password change date stored????

7. Date password last changed

8. Sp/trigger last changed date

9. Where is last password change date stored???

10. Wishlist: last changed date on sps

11. DBase header info (file size, last change date)


 
Powered by phpBB® Forum Software