Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: getting the date of table's modification

Re: getting the date of table's modification

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 17:20:23 GMT
Message-ID: <3C752C6C.F2040A46@ci.seattle.wa.us>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US