Re: Newbie Q: Does Create Index Lock Table?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 20 Aug 2000 08:27:21 +1000
Message-ID: <399f09a9$1@news.iprimus.com.au>

"Martin Haltmayer" <Martin.Haltmayer_at_0800-einwahl.de> wrote in message news:399B1264.2CC4226_at_0800-einwahl.de...
> Yes, they do unless you create the index by "create ... index ... online".
>
> Martin
>

Slap me around if I am wrong, but I'd wager a small sum that the ability to rebuild (and hence presumably to create) indexes online was only introduced in Oracle 8i. Also, even in 8i, there are big fat warnings written all over the relevant page in the training manuals -'advise students that Oracle still does not recommend that extensive DML is undertaken on a table for which Indexes are being created using the 'online' syntax'.

Also, I think you'll find that it's only b-tree indexes that can be rebuilt online in any case.

Regards
HJR
>
>
> wax_man_at_my-deja.com wrote:
> >
> > Sorry for this newbie question, but I'm just starting to learn about
> > being an Oracle DBA.
> >
> > I want to create a bitmap index on a table. Will Oracle lock the table
> > against selects while this is running? If it does, is there a way to
> > prevent it from doing this in 8.0.5?
> >
> > TIA,
> >
> > revoohc
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Sat Aug 19 2000 - 17:27:21 CDT