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. Last DML update on Oracle tables

3. How to get date last changed for table?

4. Date of last table change

5. Manipulating Dates - getting last day of month

6. Last Synchonization date not getting updated...

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

8. Date password last changed

9. Sp/trigger last changed date

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

11. Wishlist: last changed date on sps

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


 
Powered by phpBB® Forum Software