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.
dwilliams_at_lifetouch.com

-----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.
dwilliams_at_lifetouch.com

-----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: ORACLE-L_at_fatcity.com

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

cmeertins_at_pinnacle-data.com

DBA Masters

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Conrad Meertins
  INET: cmeertins_at_pinnacle-data.com

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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: cmeertins_at_pinnacle-data.com

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: ListGuru_at_fatcity.com (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: DWILLIAMS_at_LIFETOUCH.COM

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: ListGuru_at_fatcity.com (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).