Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 9i creating indexes with the ONLINE option
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?
-- jeremyReceived on Mon Oct 02 2006 - 04:23:50 CDT
============================================================
ENVIRONMENT: Oracle 9iR2 / Oracle HTTP Server / mod_plsql / Solaris 8
============================================================
![]() |
![]() |