Hi,
It seems that the table you want to drop Is being used by some user or
some application code is making use of it. So you may have to kill that
seesion that is making use of that table and then you may drop it. You
can use V$lock view to get more information.
Amar.
-----Original Message-----
From: Niketas George V.
[mailto:oracledba-ezmlmshield-x1605863.[Email address protected]
Sent: 14 November 2004 22:36
To: LazyDBA Discussion
Subject: drop a table
When I attempt to drop a table I get the following message: resource
busy and acquire with NOWAIT specified. This table seems to be locked
because I can't run any queries on it.
Thank you
George
-----------------------------------------
============================================================ The
information contained in this message may be privileged and
confidential
and protected from disclosure. If the reader of this message is not
the
intended recipient, or an employee or agent responsible for delivering
this message to the intended recipient, you are hereby notified that
any
reproduction, dissemination or distribution of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and deleting
it
from your computer. Thank you. Tellabs
============================================================
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
DISCLAIMER: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee/recipient. Access to this message by any one else is unauthorized. If you are not the intended addressee/recipient any disclosure, copying or distribution of the message, or any action or omission taken by you by relying on it is prohibited and may be unlawful. Please notify the addressor/sender immediately if you have received this message in error. The organization is not responsible for any damage caused by a virus or an alteration of the e-mail by a third party or otherwise. The contents of this message may not necessarily represent the views or the policies of the organization.
Oracle LazyDBA home page