Find out the data / time a table was last updated???

[RogerBarton]

Is there a way to find out the data / time a table was updated?

Regards,
Roger Barton

 

[SantaMufasa]

Roger,

If, by "updated", you mean most recent structural change (e.g. "CREATE" or "ALTER": [Data Definition Language (DDL)]), then you can say:

select last_ddl_time from user_objects
where object_name = upper('<subject table name>');

If, instead, you mean most recent "INSERT", "UPDATE", or "DELETE" [Data Manipulation Language (DML)], then the only method to document that is by creating a trigger that stores the date/time of changes in an audit-style table.

Oracle does not store "last update" times resulting from DML due to performance considerations.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[RogerBarton]

Greetings Mufasa!

Thanks for your reply ...
I can now see how my request was somewhat vague! Thanks for correcting the error of my ways!!!

I was actually after the last INSERT, UPDATE or DELETE - ie DML. So thankfully, you have given me an answer to this too. It was the answer that my internet searches seemed to say, but I thought it could hurt to post a question here.

Thanks again!

Regards,
Roger