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: 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).
