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

Martin T. schreef:
> 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
>

Any defaults on the new columns?
Any triggers (journaling tables!!!) firing?

Especially a combination of the two above can create unpleasant side effects on the performance of "a few DDL statements"...

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...