Message-Id: <10616.116649@fatcity.com> From: "Steve McClure" Date: Mon, 11 Sep 2000 10:23:12 -0700 Subject: Re: Index Creation question Oops I thought I mentioned the version. It is 7.3.4.3. I decided to wait and create the index this week. Considering the responses It seems that was the proper choice. When I indicated that I thought creating an index would lock the table. I really couldn't find that mentioned anywhere in the documentation or the books I commonly refer to. It seems my memory doesn't always fail me after all. Thanks to all who responded, Steve McClure ----- Original Message ----- From: Rachel Carmichael To: Multiple recipients of list ORACLE-L Sent: Saturday, September 09, 2000 6:40 PM Subject: 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" > >Reply-To: ORACLE-L@fatcity.com > >To: Multiple recipients of list ORACLE-L > >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 > > _________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > > Share information about yourself, create your own public profile at > http://profiles.msn.com. > > -- > Author: Rachel Carmichael > INET: carmichr@hotmail.com > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@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