Re: When was that index last rebuilt ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/04/14
Message-ID: <38F6FC9D.F61@yahoo.com>#1/1

Reza wrote:
>
> Hi
> I think all DDL statements are logged in alert_--.log file, I'm not sure
> about ALTER INDEX .... REBUILD , worths checking
> regards
> Peter Mckenzie <Peter.McKenzie_at_health.wa.gov.au> wrote in message
> news:8d1ifb$3c2$1_at_nnrp1.deja.com...
> > Can any kind person please tell me how to establish when an index was
> > last rebuilt. The last_ddl column on dba_objects does not update so
> > what does ?
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

DDL's are not logged to the alert log - typically only changes to the db structure (add a datafile etc etc) are

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Fri Apr 14 2000 - 00:00:00 CDT