Re: dba_objects timestamp vs last_ddl_time

nicolaou_at_netinfo.com.cy (Christos) wrote in message news:<1f2d0d84.0208280610.57aeb598_at_posting.google.com>...
> I am using the table 'dba_objects' to monitor changes on tables and
> even though I checked the Oracle Documentation I could not understand
> the difference of columns 'timestamp' and 'last_ddl_time' in the above
> table.

Hi, Christos,

If you try a DDL that does *not* change the table specification, such as GRANT SELECT ON yourtable TO SYSTEM, LAST_DDL_TIME will be current and TIMESTAMP remains the same. For a view or other dependent objects, a DDL like ALTER COMPILE would show the difference for these two columns.

Yong Huang Received on Wed Aug 28 2002 - 13:57:28 CDT