Whenever source code is changed, LAST_DDL_TIME column will be changed in dba_objects views. This column LAST_DDL_TIME represents the last change of any object in database
How are you?
Thanks for replying.
See where my doubt comes from.
I had fourteen objects on column last_ddl_time with today´s date, so, I ran the package utl_recomp to compile all database objects. after compile is done, I found fourty two objects on column last_ddl_time with today´s date but the source code of this objects was not change, the source code is the same for all objects compiled.
I need to know the update date only the objects that really changed the source code.