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

Build another table with the same DDL but a different name. Try your script on it.

Assuming what you've said I'd be thinking corrupt block/segment or a lock that was not properly released.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group