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

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? Received on Thu Sep 21 2006 - 11:43:33 CDT