Re: getting the date of table's modification

Look at the various types of SYSTEM triggers that can catch DDL. One or more will fit the bill.

Daniel Morgan

Scott Mattes wrote:

> 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 - 18:24:04 CST