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.
> 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: Jared Still
  INET: jkstill_at_cybcon.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).