Thank you. I was hoping for something that Oracle provided, since I wouldn't
be able to put a trigger on any of the tables in question.
"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
news:3C758FB9.D9F9AEE9_at_ci.seattle.wa.us...
> 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 - 20:06:48 CST
