Xref: alice comp.databases.oracle.server:83085 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.icl.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.tli.de!newsfeed2.news.nl.uu.net!sun4nl!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail From: "Sybrand Bakker" Newsgroups: comp.databases.oracle.server Subject: Re: release resource locks Date: Wed, 2 Feb 2000 18:50:24 +0100 Message-ID: <949513952.28931.0.pluto.d4ee154e@news.demon.nl> References: <879l0c$jcu$1@nnrp1.deja.com> Reply-To: "Sybrand Bakker" X-Trace: news.demon.nl 949513952 pluto:28931 NO-IDENT sybrandb.demon.nl:212.238.21.78 X-Complaints-To: abuse@nl.demon.net X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Lines: 24 The error means the table is in use, and you are trying to execute a DML operation on it. Of course this is not allowed. The only thing you can do is wait and retry later. Sorry, -- Sybrand Bakker, Oracle DBA maylee wrote in message news:879l0c$jcu$1@nnrp1.deja.com... > How can I release a lock from a table. The sessionn cannot be killed. > > I am getting this error... > > ORA-00054: resource busy and acquire with NOWAIT specified > > > > Sent via Deja.com http://www.deja.com/ > Before you buy.