Use auditing, or include timestamp column in your table. Igor Neyman, OCP DBA [EMAIL PROTECTED]
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 6:53 AM > > From: "Stephane Faroult"<[EMAIL PROTECTED]> > > Date: Wed, 11 Sep 2002 11:24:50 UT > > Subject: RE: Index table last update? > > > >>----- Original Message ----- > >>From: "O'Neill, Sean" <[EMAIL PROTECTED]> > >>Sent: Wed, 11 Sep 2002 03:13:21 > >>Is there a way to determine when an index table was > >>last updated?.=0D > > > >The answer is the same as with heap tables. > > > >Regards, > > > >Stephane Faroult > >Oriole > > Stephane, > > Totally confused by your reply. Could you give me a 101 explanation pleez. > > Regards, > - Sean > -------------------------------------------------------------------- > This message, including attached files, may contain confidential > information and is intended only for the use by the individual > and/or the entity to which it is addressed. Any unauthorized use, > dissemination of, or copying of the information contained herein is > not allowed and may lead to irreparable harm and damage for which > you may be held liable. If you receive this message in error or if > it is intended for someone else please notify the sender by > returning this e-mail immediately and delete the message. > -------------------------------------------------------------------- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: O'Neill, Sean > 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman 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).
