When was an Object Changed ?


Is there a utility in Oracle where it can compare when the object was changed last?
Or tell us when it was changed last ?

Will this include any object where a user just recompiled but didn't change anything ?
 
OCUBEAsked:
Who is Participating?
 
ajexpertConnect With a Mentor Commented:
You can check LAST_DDL_TIME to check when was the object changed last, but it wont tell what was changed.

SELECT LAST_DDL_TIME
FROM USER_OBJECTS WHERE OBJECT_NAME = '<YOUR_OBJECT_NAME>'

You may want to look at Oracle change management pack

http://download.oracle.com/docs/cd/B28359_01/license.111/b28287/options.htm#CIHBGJCC

Hope it helps
0
 
OCUBEAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.