Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Alter Table and ORA-00054 (only one connection)?

Re: Alter Table and ORA-00054 (only one connection)?

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: 21 Sep 2006 09:52:09 -0700
Message-ID: <1158857529.335319.248110@e3g2000cwe.googlegroups.com>


gazzag wrote:
> Martin T. wrote:
> > Hi all!
> > (Oracle 9.2.0.1.0, Windows XP)
> >
> > I have an update script for a schema that changes a number of tables,
> > does a few insert, updates package specs etc.
> >
> > When I run this sql script on my test DB against the schema (no other
> > connections under the same schema user) for *some* column-adds I get:
> > ALTER TABLE SHIFT_ORDERS ADD (SYS_ORDER_TIME NUMBER)
> > *
> > ORA-00054: resource busy and acquire with NOWAIT specified
> >
> > For some other table alterations the script works.
> >
> > When I run the ALTER commands separately, they always succeed ... ?
> >
> > I guess for some strange reason I'm locking myself, but how can I
> > determine the cause of the lock? (How could I make use of v$access to
> > determine the cause of this?)
> >
> > Any pointers welcome!
> >
> > best,
> > Martin
>
> Are you sure that there are no other background processes, for example,
> logged into the database?
>
> What does gv$session show you?

Yes, I'm 100% sure no other session that the one opened by the script are active. We are only two developers on this test DB. Also the schema the script runs against is freshly created from an export dump. No jobs run that access this schema.

Can it be that an uncommited DML in a earlier part of the script locks something? (I thought to know that ALTER implies commit though.)

best,
Martin Received on Thu Sep 21 2006 - 11:52:09 CDT

Original text of this message

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