Re: [Q] Online rebuild index danger or NOT???
- From: jonathan@xxxxxxxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 23 Oct 2007 15:34:11 +0100
> Date: Mon, 22 Oct 2007 12:55:22 -0700 (PDT)
> From: dba1 mcc <mccdba1@xxxxxxxxx>
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
