Re: Table locked while rebuilding index

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Thu, 01 May 2003 19:13:23 +0200
Message-ID: <sbl2bvgq6c112lv35fpvra8vp6sqage088@4ax.com>

On Thu, 1 May 2003 18:38:02 +0200, "MK" <hello_at_foo.com> wrote:

>Pardon my ignorance, but:
>
>I've just discovered I can not insert a row into a table whose
>index is just being created (CREATE INDEX...).
>
>Does this mean an Oracle table is locked while its index is being
>created, or am I doing something terribly wrong?
>

Yes, it is locked

>Is there a way to have a table available for writing (and reading),
>while its index is being created? Something like
>CREATE INDEX IN THE BACKGROUND ...
>
>I work with Oracle 8.1.7.
>

AFAIK online index build is a 9i feature and 8i is desupported at the end of this year anyway

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu May 01 2003 - 12:13:23 CDT