Re: getting the date of table's modification

SELECT created, last_ddl_time
FROM user_objects
WHERE object_name = 'XXX';

Daniel Morgan

Paolo wrote:

> Hi everybody,
>
> how may I get date of table's modification ?
> ( modification = newly created, or just insert, delete, update)
>
> I tried something like:
>
> select object_name, last_ddl_time
> from dba_objects
> where object_name = 'MY_TABLE'
>
> But after I modified table MY_TABLE (for example with an update)
> the result from the query above is the same, and nothing changed.
> I wonder where my mistake is.
>
> Thanks in advance for any help, kind regards,
> Paolo
>
> PS:
> using Oracle 7.3.3 under AIX 4.3.1
Received on Thu Feb 21 2002 - 11:20:23 CST