Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why index cannot be created on locked table
Create index is a DML statement. So it does a commit before and after.
Since all DML is a transaction by itself, it has to be separate from the
transaction that did the table lock. Since the table was not locked by you,
and since a table lock disallows any row locking operations until the table
is unlocked, the create index can't do its job.
<kvsraju_at_my-dejanews.com> wrote in message
news:7df1a5$qnv$1_at_nnrp1.dejanews.com...
> HI,
> Here i have a doubt.
> Why Oracle is unable to create an index on a table which is locked.
> Can anyone give explanation on this.
> If so,
> Thanx in advance.
>
> kvsraju
>
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 25 1999 - 23:44:50 CST