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 -> create index on table with changing data

create index on table with changing data

From: John F. Burrill <burrill_at_sourceworks.com>
Date: Mon, 20 Dec 1999 19:23:13 GMT
Message-ID: <385E8380.3C648238@sourceworks.com> 





We are trying to create an index on a table that is being
accessed and updated continously via the web.  When
creating the index, the connecting processes build up
and the create index takes so long that we have to kill it.



How can we create the index without taking the database
offline to users?



Kindest regards,


John F. Burrill.

Received on Mon Dec 20 1999 - 13:23:13 CST












Original text of this message













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