Re: ORA-00054: resource busy and acquire with NOWAIT specified

"Ginrai" <Ginrai_at_hotmail.com> wrote in message news:9nuep2$pn225_at_hkunae.hku.hk...
> Dear all,
>
> When I typed the command as follow, the error message occurs.
> However it seems that I am the only user who use this table and the
servlet
> program connected to the database also restarted.
>
> More I also drop all the trigger related to this table. Any method to
> correct this problem? Thank you very much for all your help!
>
> SQL> alter table source add ( currency2 varchar2(2))
> 2 /
> alter table source add ( currency2 varchar2(2))
> *
> ERROR at line 1:
> ORA-00054: resource busy and acquire with NOWAIT specified
>
> Regards,
> Ginari
>
>

'However it seems that I am the only user who use this table' This error only occurs when Oracle has a DDL lock on the table ( a lock on the record for the table in the datadictionary), so evidently Oracle doesn't agree with you.
Please refer to the v$db_object_cache or v$access view to check who's correct.
Most likely you aren't

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 14 2001 - 23:18:27 CDT