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 -> Re: Index creation on large tables

Re: Index creation on large tables

From: Sean Fitzgerald <sfitzgerald_at_centuryinter.net>
Date: Wed, 12 May 1999 22:21:58 -0400
Message-ID: <PKq_2.12366$_m5.2138324@newsread1-mx.centuryinter.net> 






You can't insert into the table while the index is being created -- any dml
is locked out.  Try creating the index using the unrecoverable and paralle
option to speed the process (assuming you run 7.3 or higher) and have
multiple processors.


Received on Wed May 12 1999 - 21:21:58 CDT












Original text of this message













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