Re: Oracle 7.3.4 Real-Time Re-indexing

Have you used parallel clause while rebuilding? What version of 7.3.4 ?

Check alert_SID.log for any possible index corruption.... If any , then you have to check for table and all indexes on that. Find index/es with multiple keys , save their defination through export , drop those indexes and create again...Check for invalids (using dba_objects) and recompile....

You can analyze table by using 'analyze table table_name validate structure cascade; and check alert_log. for possible corruption of that table indexes....

If you have any any specific question then please let me know...

Regards
Rafiq

Have y

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Mon, 13 Jan 2003 06:38:46 -0800

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

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: M Rafiq
  INET: rafiq9857_at_hotmail.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).