Re: [Q] Online rebuild index danger or NOT???

From: <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 23 Oct 2007 15:34:11 +0100
Message-Id: <E1IkKpf-0009hb-Hh@pr-webmail-2.demon.net>

> Date: Mon, 22 Oct 2007 12:55:22 -0700 (PDT)
> From: dba1 mcc <mccdba1_at_yahoo.com>
> Subject: [Q] Online rebuild index danger or NOT???
>
> We have ORACLE 10gr2 on Redhat server. Our
> application vendor told me don't "online rebuild
> index". They suggest kick out all users then rebuild
> index.
>
> I have been online rebuild index on several databases
> since ORACLE 8.1.7 and NO problem.
>
> I don't know why application vendor suggest don't
> "online rebuild index". I like listen your
> experience.
>
> Thanks.
>

Oneline / Offline - doesn't matter; accidents can happen intermittently to random processes.

http://jonathanlewis.wordpress.com/2007/09/16/index-rebuild/

Regards
Jonathan Lewis

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 23 2007 - 09:34:11 CDT