Re: Newbie Q: Does Create Index Lock Table?

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sun, 20 Aug 2000 08:24:09 +1000
Message-ID: <399f08e9$2@news.iprimus.com.au>

<wax_man_at_my-deja.com> wrote in message news:8nem1b$bt4$1_at_nnrp1.deja.com...
> 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?
>

Yes, it locks the table. And no, there is no way of preventing it from doing so -since Oracle must determine the entire set of possible values for a given column before it can construct the bitmap. It couldn't do that if updates were happening at the same time.

Regards
HJR
> TIA,
>
> revoohc
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Aug 19 2000 - 17:24:09 CDT