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 <carmichr_at_hotmail.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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" <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
>
> _________________________________________________________________________
> 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_at_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_at_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
Received on Mon Sep 11 2000 - 12:23:12 CDT