Re: Newbie Q: Does Create Index Lock Table?

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Thu, 17 Aug 2000 00:15:00 +0200
Message-ID: <399B1264.2CC4226@0800-einwahl.de>

Yes, they do unless you create the index by "create ... index ... online".

Martin

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 Wed Aug 16 2000 - 17:15:00 CDT