RE: When was an index last rebuilt?

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 3 Jan 2001 00:13:26 -0000
Message-Id: <10729.125563@fatcity.com>

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:

"

From: Oracle, Helen Schoone 27-Nov-00 12:44 Subject: Re : How to know when an index was rebuilt

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
mailto:bruce.reardon_at_comalco.riotinto.com.au Received on Tue Jan 02 2001 - 18:13:26 CST