Oracle 7.3.4 Real-Time Re-indexing - Additional Information
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).
RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
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).
RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
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).
RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
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).
Re: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
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).
RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
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.fat
RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
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 wa
RE: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
Yes, it is as of today...We are still having 7.3.4.5 for our Oracle Financials 10.7 Application. This may be the last year for this version... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Mon, 13 Jan 2003 12:38:39 -0800 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 --
Re: Oracle 7.3.4 Real-Time Re-indexing - Additional Information
Were you analyzing while rebuilding Indexes ? If that is the case.. there are chances of possible corruption. Try to give select count(*) from table_name; and select * from table_name; Hope this may provide you with some answer. HTH - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 06:43 AM > > 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: Nikunj Gupta 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).