one way to resolve this error is to restart the database , even I hve
faced
Similar type of error got resolved when I asked my DBA's to shutdown my
database
And start it again

Regards
Anu

-----Original Message-----
From: Jagannathan Gowrish
[mailto:oracledba-ezmlmshield-x92851063.[Email address protected]
Sent: Friday, February 29, 2008 4:04 PM
To: LazyDBA Discussion
Subject: RE: Alter table : Help

You are not able to acquire the lock since some else/session is using
this object.

-----Original Message-----
From: Nagarajan VinodhKumar
[mailto:oracledba-ezmlmshield-x43162121.[Email address protected]
Sent: Friday, February 29, 2008 3:03 PM
To: LazyDBA Discussion
Subject: Alter table : Help

Hi all ,

While trying to alter the table i got this error . what can i do to
get rid of this.

alter table jcal drop column end_date
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified



Thanks & Regards
vinodh.

Confidential: This electronic message and all contents contain
information from Syntel, Inc. which may be privileged, confidential or
otherwise protected from disclosure. The information is intended to be
for the addressee only. If you are not the addressee, any disclosure,
copy, distribution or use of the contents of this message is prohibited.
If you have received this electronic message in error, please notify the
sender immediately and destroy the original message and all copies.

Confidential: This electronic message and all contents contain
information from Syntel, Inc. which may be privileged, confidential or
otherwise protected from disclosure. The information is intended to be
for the addressee only. If you are not the addressee, any disclosure,
copy, distribution or use of the contents of this message is prohibited.
If you have received this electronic message in error, please notify the
sender immediately and destroy the original message and all copies.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


_______________________________________________

This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: www.barcap.com/emaildisclaimer. By messaging with Barclays you consent to the foregoing. Barclays Capital is the investment banking division of Barclays Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP. This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________

Oracle LazyDBA home page