Path: news.easynews.com!easynews!zeus.visi.com!news-out.visi.com!hermes.visi.com!news1.optus.net.au!optus!spool01.syd.optusnet.com.au!spool.optusnet.com.au!210.49.20.119.MISMATCH!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: <9HGR7.9955$I3.147843@news.bora.net> Subject: Re: (create index) vs (create index ... online) Date: Wed, 12 Dec 2001 22:04:24 +1100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 26 Message-ID: <3c173969$0$5901$afc38c87@news.optusnet.com.au> NNTP-Posting-Host: 211.28.77.175 X-Trace: 1008154987 5901 211.28.77.175 Xref: easynews comp.databases.oracle.server:127931 X-Received-Date: Wed, 12 Dec 2001 04:05:03 MST (news.easynews.com) 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" wrote in message news:9HGR7.9955$I3.147843@news.bora.net... > Any difference? > > I can't find any informattion in manual about that. > > Thanks in advance.. > > > >