Re: getting the date of table's modification

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Fri, 22 Feb 2002 17:19:00 GMT
Message-ID: <3C767D9B.1F4371DD@ci.seattle.wa.us>

Excuse me ... But ...

"I updated all rows for a given field" is NOT DDL. It is DML.

DML stands for "Data Manipulation Language" and that is what you did ... you manipulated the data.

If you want DDL try

ALTER TABLE xyz
ADD (new_column VARCHAR2(20));

and see what happens.

Daniel Morgan

Paolo wrote:

> 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 - 11:19:00 CST