Though I'm not sure, I *believe* that in 7.3 indexes must be taken offline during a rebuild.
That being the case, your users queries would not have executed properly. i.e. FTS would take place for queries that normally used indexed access. Jared On Monday 13 January 2003 08:14, Conrad Meertins wrote: > ALTER .......REBUILD.. > > Thanks > > COnrad.. > > > -----Original Message----- > WILLIAMS > Sent: Monday, January 13, 2003 10:19 AM > To: Multiple recipients of list ORACLE-L > > > Conrad - What command did you use to re-index? Drop index / create index? > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Monday, January 13, 2003 8:44 AM > To: Multiple recipients of list ORACLE-L > > > > Sorry, I forgot this additional infromation... > > Oracle created invalid objects when we ran rebuild. The odd thing was that > the trace file showed an invalid object but the all_objects table showed a > valid object. > > > > -----Original Message----- > Sent: Monday, January 13, 2003 9:39 AM > To: [EMAIL PROTECTED] > > > > Team, > > I have a Oracle 7.3.4 database on a AIX box that is in Archive Log Mode. > While the users were on the system, we Re-Indexed our tables. > Situation: The users complained, that they were unable to process their > orders. > Although, the log file showed that the re-indexing was successful, the > users were still unable to process their orders. > > > QUESTION: Are they any known issues/pit-falls when re-indexing real-time in > version 7.x? > > Should you have the database in exclusive mode when re-indexing? > > Please assist. > > Thanks > > Conrad Meertins > > [EMAIL PROTECTED] > > DBA Masters > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Conrad Meertins > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
