Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: getting the date of table's modification
Is there some table/field that shows the last time someone added/changed a
table field?
Thank you.
"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
news:3C752C6C.F2040A46_at_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 - 12:31:59 CST