Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index Creation question
what version are you running? I believe that in the latest version(s) you
can do an index rebuild without locking the table. Or am I thinking of a 3rd
party product?
Rachel
>From: "Allan Nelson" <anelson_at_houston.rr.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Index Creation question
>Date: Sat, 09 Sep 2000 08:15:26 -0800
>
>I think you are right. When I do index rebuilds I have to be the only one
>able to hold locks.
>
>Allan
> ----- Original Message -----
> From: Steve McClure
> To: Multiple recipients of list ORACLE-L
> Sent: Friday, September 08, 2000 6:40 PM
> Subject: Index Creation question
>
>
> I have a question about creating an index on a production OLTP database.
> This type of work I usually schedule for weekends or late at night when
>downtime would cause minimal problems. The client I am currently working
>for, as a developer not a DBA--I learn about all things DBA as I go--, is
>asking me to do this in the middle of the day. The deal is I am going away
>for the weekend and won't be able to do it until next week when I return.
>
> Anyway my reservation has to do with incoming transactions during the
>index build. First I have this thought in the back of my head that
>creating an index will lock the table, but I can't really say where that is
>coming from. Secondly I am certain that it will have a negative impact on
>transactions during the index creation. We are talking about 4 million
>rows in the table, and it is THE table read and written to during OLTP.
>
> Am I just being paranoid, or should I make them wait?
>
> Steve McClure
Share information about yourself, create your own public profile at Received on Sat Sep 09 2000 - 19:36:28 CDT