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 -> 9i creating indexes with the ONLINE option

9i creating indexes with the ONLINE option

From: Jeremy <jeremy0505_at_gmail.com>
Date: Mon, 2 Oct 2006 10:23:50 +0100
Message-ID: <MPG.1f8aeaf42e683c0198a2ea@news.individual.net>

Hi folks, anyone experienced any problems with creating indexes on table in 9iR2 specifying the ONLINE option?

It doesn't *appear* to do as expected - i.e. allowing a new index to be created on a table whilst DML is occurring on the table on which the index is being built. All DML was suspended pending completion of the index creation when I tried this yesterday:

  create index mytab_n1
  on mytab (date_start) ONLINE
  tablespace ts_index;

Are there some known bugs with this? Or am I missing something?

-- 
jeremy


============================================================
ENVIRONMENT: Oracle 9iR2 / Oracle HTTP Server / mod_plsql / Solaris 8
============================================================
Received on Mon Oct 02 2006 - 04:23:50 CDT

Original text of this message

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