which is why I suggested timestamp. Grants will change last_ddl_time, but
not timestamp. That changes on "create or replace" of a procedure, so it
probably does (at least when the bug is fixed, as it is in 8.1.7) the same
for indexes.
>From: Casey Dyke <cdyke_at_excitehome.com.au>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: When was an index last rebuilt?
>Date: Tue, 02 Jan 2001 17:50:21 -0800
>
>Perhaps a mute point to note that a number of other operations could update
>the column and mask an index rebuild. If DDL is quiet other than index
>rebuilds, then monitoring this column may prove satisfactory. Have a vague
>recollection that grants and the like can modify this column - emphasis on
>vague. Would be interesting to know exactly which events do talk to this
>column though. Perhaps an API for all index rebuilds that logs its work
>could
>be a solution?
>
>:0)
>
> > Hi,
> >
> > As of 8.1.5 this information is not stored in any of timestamp,
> > last_ddl_time nor the created field.
> >
> > However, this is a bug (1096399) and rebuilding an index should update
> > last_ddl_time - see excerpt below from a Metalink forum:
> >
> > "
> >
> > Hi. ALTER INDEX ... REBUILD does not update DBA_OBEJCTS.LAST_DDL_TIME in
> > Oracle7/8. This is documented in bug 1096399. This bug is fixed in 8.1.7
> > where an ALTER INDEX ... REBUILD of a non-partitioned index will update
>the
> > LAST_DDL_TIME column of DBA/USER/ALL_OBJECTS.
> > "
> >
> > The bug details state that the data_object_id field does get updated in
> > versions below 817, so if really needed then perhaps this field could be
> > used as a flag to indicate index rebuilds.
> >
> > Regards,
> > Bruce Reardon
> >
><< cdyke.vcf >>
Get your FREE download of MSN Explorer at
http://explorer.msn.com
Received on Tue Jan 02 2001 - 21:08:09 CST
