8.1.6
>From: "Jack C. Applewhite" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: LAST REBUILD INDEX >Date: Mon, 01 Apr 2002 10:17:42 -0800 > >Seema, > >What version are you on? For 8.1.7.3.0 under Win2k Last_DDL_Time in >DBA_Objects *does* show when an Index last had an "Alter Index <xxx> >Rebuild" executed against it. I just now tested to verify that. > >Jack >-------------------------------- >Jack C. Applewhite >Database Administrator/Developer >OCP Oracle8 DBA >iNetProfit, Inc. >Austin, Texas >www.iNetProfit.com >[EMAIL PROTECTED] >(512)327-9068 > > >-----Original Message----- >Sent: Monday, April 01, 2002 11:42 AM >To: Multiple recipients of list ORACLE-L > > >Jack >No! >thx >-Seema > > > >From: "Jack C. Applewhite" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: LAST REBUILD INDEX > >Date: Mon, 01 Apr 2002 08:53:33 -0800 > > > >Seema, > > > >Probably Last_DDL_Time in DBA_Objects, though that just tells you the >last > >time any DDL was executed on the object. > > > >Jack > > > >-------------------------------- > >Jack C. Applewhite > >Database Administrator/Developer > >OCP Oracle8 DBA > >iNetProfit, Inc. > >Austin, Texas > >www.iNetProfit.com > >[EMAIL PROTECTED] > >(512)327-9068 > > > > > >-----Original Message----- > >Sent: Monday, April 01, 2002 9:58 AM > >To: Multiple recipients of list ORACLE-L > > > > > >Hi > >WHich view show when was the last rebuild of indexes? > >Thx > >-Seema > > > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jack C. Applewhite > INET: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). _________________________________________________________________ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
