Re: Table locked while rebuilding index

create index .. online;

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?
>
>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.
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Thu May 01 2003 - 12:11:39 CDT