Vinodh,

Use the following query to find who is accessing the table and kill the
session if needed to alter the table immediately.

select * from v$access where lower(object) = ' jcal';

Thanks
B

-----Original Message-----
From: Nagarajan VinodhKumar
[mailto:oracledba-ezmlmshield-x43162121.[Email address protected]
Sent: Friday, February 29, 2008 1:33 AM
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



Oracle LazyDBA home page