Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
dba_objects timestamp vs last_ddl_time
1,783 views
Skip to first unread message
Christos
Aug 28, 2002, 10:10:38 AM8/28/02
to
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.
even though I checked the Oracle Documentation I could not understand
the difference of columns 'timestamp' and 'last_ddl_time' in the above
table.
Could somebody help me with this?
Yong Huang
Aug 28, 2002, 2:57:28 PM8/28/02
to
nico...@netinfo.com.cy (Christos) wrote in message news:<1f2d0d84.02082...@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.
> 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
Christos
Aug 29, 2002, 1:49:37 AM8/29/02
to
Thanks a lot Yong...
0 new messages