Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index Creation question

Re: Index Creation question

From: Steve McClure <>
Date: Mon, 11 Sep 2000 10:23:12 -0700
Message-Id: <>

Oops I thought I mentioned the version. It is 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

> 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
> party product?
> Rachel
> >From: "Allan Nelson" <>
> >Reply-To:
> >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
> >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
> > 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
> >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
> >coming from. Secondly I am certain that it will have a negative impact
> >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
> Share information about yourself, create your own public profile at
> --
> Author: Rachel Carmichael
> 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: (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
Received on Mon Sep 11 2000 - 12:23:12 CDT

Original text of this message