Resolve TM lock

From: Chuan Zhang <chuan_at_asiaonline.net>
Date: Wed, 22 Nov 2000 15:04:30 +1100
Message-Id: <10687.122686@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C05495.840A9440 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi, all

I got an error when I drop a table "ORA-00054: resource busy and = acquire with NOWAIT specified".

I figure out that table was locked by a session. Therefore, I use "alter = system kill session 'sid,serial#' " to kill session. Finally, that = session is marked "killed".=20

Again, I still cannot drop that table.=20

Have any idea what anything I can do for this situation.

My platform is on Solaris 2.7, Oracle EE 8.1.5.

Many Thanks

Chuan

------=_NextPart_000_000A_01C05495.840A9440 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi, all</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>  I got an error when I drop a =
table=20
"ORA-00054: resource busy and acquire with NOWAIT = specified".</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I figure out that table was locked by a =
session.=20
Therefore, I use "alter system kill session 'sid,serial#' " to kill = session.=20
Finally, that session is marked "killed". </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Again, I still cannot drop that table.=20
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Have any idea what anything I can do =
for this=20
situation.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>My platform is on Solaris 2.7, Oracle =
EE=20
8.1.5.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Many Thanks</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Chuan</FONT></DIV></BODY></HTML>
Received on Tue Nov 21 2000 - 22:04:30 CST