Message-Id: <10687.122686@fatcity.com> From: "Chuan Zhang" Date: Wed, 22 Nov 2000 15:04:30 +1100 Subject: Resolve TM lock 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

Hi, all

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

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".

Again, I still cannot drop that table.=20

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

My platform is on Solaris 2.7, Oracle = EE=20 8.1.5.

Many Thanks

Chuan