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

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 Received on Thu Sep 21 2006 - 11:34:02 CDT