Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Table locked while rebuilding index

Table locked while rebuilding index

From: MK <hello_at_foo.com>
Date: Thu, 1 May 2003 18:38:02 +0200
Message-ID: <b8rik8$cmdva$1@ID-174077.news.dfncis.de>


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. Received on Thu May 01 2003 - 11:38:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US