Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table locked while rebuilding index
Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<sbl2bvgq6c112lv35fpvra8vp6sqage088_at_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
Just for the record, the online index rebuilds feature was introduced with 8.1
I have used it a couple of times and on moderately accessed tables of moderate size (small to 200M) it appeared to work without causing a problem.