Re: Oracle 7.3.4 Real-Time Re-indexing

[M Rafiq]

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: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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

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

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