RE: When was an index last rebuilt?

I can confirm that last_ddl_time is NOT updated in 8.1.6 NT (rebuilt a bunch of indexes yesterday - still showing Dec 2000 last_ddl_time). I await 8.1.7.

Another post said that other actions can update the last_ddl_time column (eg grants). Given that we are talking indexes (so grants not applicable?) anybody know what other actions will cause the ddl_time column for an index object to be updated hence messing up using this as a monitor for index rebuilds?. I analyse my production schema every night and the last_ddl_time for the index has not been changed I'm assuming that analyse does not.

Regards

-----Original Message-----
From: Reardon, Bruce (CALBBAY)
[mailto:Bruce.Reardon_at_comalco.riotinto.com.au] Sent: 03 January 2001 00:15
To: Multiple recipients of list ORACLE-L Subject: RE: When was an index last rebuilt?

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
mailto:bruce.reardon_at_comalco.riotinto.com.au

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).