How can I check the time a table was last updated in Oracle?

Question

I need to write a script that will check that a table has been updated within the last 30 mins. Is there a v?iew I can query with this information?

Answer 1

You have to be auditing the table to keep this information Or have a modified date time on the table which is updated whenever a row is.