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: (create index) vs (create index ... online)

Re: (create index) vs (create index ... online)

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 12 Dec 2001 22:04:24 +1100
Message-ID: <3c173969$0$5901$afc38c87@news.optusnet.com.au>


Yes there is a difference.

The online option doesn't take a complete table lock for the duration of the create. DML on the underlying table is thus permitted throughout.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Konghun Choi" <ashydays_at_shinbiro.com> wrote in message
news:9HGR7.9955$I3.147843_at_news.bora.net...

> Any difference?
>
> I can't find any informattion in manual about that.
>
> Thanks in advance..
>
>
>
>
Received on Wed Dec 12 2001 - 05:04:24 CST

Original text of this message

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