Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: getting the date of table's modification
I meant when an 'alter table' command, or the like, is issued against the
table. Despite the stated goal of this project going live a long time ago,
the customer is still making table changes weekly. I sometimes think that
maybe some changes are slipping thru the notifying the developers crack, so
if there was some way to check this automatically...
"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
news:3C756613.911A0E8C_at_ci.seattle.wa.us...
> Do you mean the data in the field? Or issued DDL to alter the field's
> properties?
>
> If the former ... that is something you must design into your table
structure
> and update with your SQL or through a trigger.
>
> Daniel Morgan
>
>
>
> Scott Mattes wrote:
>
> > 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 - 16:51:10 CST