Thanks Rafiq. As I said, my 7.3.4 knowledge is too old by now (but man, was that a great version).
Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, January 13, 2003 1:22 PM To: Multiple recipients of list ORACLE-L Dennis, Here/ in this senario ' 'ANALYZE INDEX VALIDATE STRUCTURE' will not help or reveal anything except to anlyze table with cascade structure which will reveal any index corruption relating to that table. There was a bug in 7.3.4.3 where index rebuilding with parallel clause was resulting in corrupt indexes with multiple keys. Indexes with single index key were ok... I think it should be the problem.... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Mon, 13 Jan 2003 09:29:04 -0800 Conrad - I haven't used 7.3.4 in quite some time, so my knowledge is a little rusty. If you search METALINK, you will find quite a few issues with this command on various Oracle versions. I believe that the basic principle is the same - Oracle builds a new index in the background, syncs up any table changes that have been made since the index build began, then switches which index is being used for queries. I think I heard somewhere that the locking/syncing mechanism has been improved in more recent Oracle versions. Perhaps someone else on the list has some specific knowledge. The database doesn't need to be in exclusive mode, but common sense would be to avoid rebuilding when the table is being heavily modified. Once you complete, you can ANALYZE INDEX VALIDATE STRUCTURE just to be sure you don't have any problems. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Monday, January 13, 2003 10:14 AM To: Multiple recipients of list ORACLE-L 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). -- 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). _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: M Rafiq 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).
