-
Are there any Oracle tables which keep track of when a table was last updated via a DML statement?
I would love a select like
select table_name from user_tables
where last_dml_update_done > sysdate - 5.
I don't want to use auditing, and was just wondering if there are any internal Oracle tables that keep track of this.
I do have SYS_UPDATE_TIME on most of my tables, which does give me what I want. But it's the tables which don't have this column that I'm trying to work on.
Thanks,
Paul
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|