Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: (create index) vs (create index ... online)
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...Received on Wed Dec 12 2001 - 05:04:24 CST
> Any difference?
>
> I can't find any informattion in manual about that.
>
> Thanks in advance..
>
>
>
>