I need to clear up one database and find out which table has not been used for a while. Is there any utilities provided information such as last updated date to the table? thanks.
If you mean updated here is the data (DML)... you will know that if you have yout auditing enabled. Otherewise, I don't know of any views, and I am also eager to know of such view or table.
But if you mean updated here is the table (DDL) itself or the object, you can use dba_objects view to see the last_ddl_time performed on the object.
Lets wait for other postings.
Robbie
"The rule is, not to besiege walled cities if it can possibly be avoided" -- Art of War
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.