Re: getting the date of table's modification

I used your select, but the result is the same as for mine,  i.e. even after a DDL operation on table 'XXX' (I updated all rows for a given field) , date fields CREATE and LAST_DDL_TIME remain unchanged.

What is the problem then ?

On Thu, 21 Feb 2002 17:20:23 GMT, damorgan <dan.morgan_at_ci.seattle.wa.us> wrote:

--->SELECT created, last_ddl_time
--->FROM user_objects
--->WHERE object_name = 'XXX';
--->
--->Daniel Morgan
Received on Fri Feb 22 2002 - 06:56:49 CST