| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Resource busy error
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C05951.3A7C3000
Content-Type: text/plain;
charset="iso-8859-1"
This bug was closed in 1999.
Alex Hillman
-----Original Message-----
From: aaaa wwwwww [mailto:krisibm_at_lycos.com]
Sent: Monday, November 27, 2000 7:45 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Resource busy error
Dear
Go through patch 646135
Rao
-- On Mon, 27 Nov 2000 14:35:57 cemail wrote:Received on Tue Nov 28 2000 - 09:38:15 CST
>
>. Sometimes while trying to do a simple "truncate
>table table_name", we get the error ORA-00054: resource busy
>and acquire with NOWAIT specified. We aren't using a NOWAIT
>keyword and there isn't anybody else on the database. After
>we get the error, we can't do the truncate without shutting down
>the database. What can be done to prevent this random error
>and what can be done so that after this error occurs, we can
>still run truncate without having to shut down?
>
>(Not sure but I think the developers may be killing a truncate
>the first time around and this error may be occurring the second
>time they try to run it.)
>
>-----
>Sent using MailStart.com ( http://MailStart.Com/welcome.html )
>The FREE way to access your mailbox via any web browser, anywhere!
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: cemail_at_sprintmail.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com ------_=_NextPart_001_01C05951.3A7C3000 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Resource busy error</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>This bug was closed in 1999.</FONT> </P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: aaaa wwwwww [<A = HREF=3D"mailto:krisibm_at_lycos.com">mailto:krisibm_at_lycos.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Monday, November 27, 2000 7:45 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Resource busy error</FONT> </P> <BR> <P><FONT SIZE=3D2>Dear</FONT> </P> <P><FONT SIZE=3D2>Go through patch 646135</FONT> </P> <P><FONT SIZE=3D2>Rao</FONT> <BR><FONT SIZE=3D2>--</FONT> </P> <P><FONT SIZE=3D2>On Mon, 27 Nov 2000 14:35:57 </FONT> <BR><FONT SIZE=3D2> cemail wrote:</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>. Sometimes while trying to do a simple = "truncate</FONT> <BR><FONT SIZE=3D2>>table table_name", we get the error = ORA-00054: resource busy</FONT> <BR><FONT SIZE=3D2>>and acquire with NOWAIT specified. We = aren't using a NOWAIT</FONT> <BR><FONT SIZE=3D2>>keyword and there isn't anybody else on the = database. After</FONT> <BR><FONT SIZE=3D2>>we get the error, we can't do the truncate = without shutting down</FONT> <BR><FONT SIZE=3D2>>the database. What can be done to prevent = this random error</FONT> <BR><FONT SIZE=3D2>>and what can be done so that after this error = occurs, we can</FONT> <BR><FONT SIZE=3D2>>still run truncate without having to shut = down?</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>(Not sure but I think the developers may be = killing a truncate</FONT> <BR><FONT SIZE=3D2>>the first time around and this error may be = occurring the second</FONT> <BR><FONT SIZE=3D2>>time they try to run it.)</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>-----</FONT> <BR><FONT SIZE=3D2>>Sent using MailStart.com ( <A = HREF=3D"http://MailStart.Com/welcome.html" = TARGET=3D"_blank">http://MailStart.Com/welcome.html</A> )</FONT> <BR><FONT SIZE=3D2>>The FREE way to access your mailbox via any web = browser, anywhere!</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>-- </FONT> <BR><FONT SIZE=3D2>>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>>-- </FONT> <BR><FONT SIZE=3D2>>Author: </FONT> <BR><FONT SIZE=3D2>> INET: cemail_at_sprintmail.com</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>>-----------------------------------------------------------= ---------</FONT> <BR><FONT SIZE=3D2>>To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>>the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>>(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>>also send the HELP command for other information = (like subscribing).</FONT> <BR><FONT SIZE=3D2>></FONT> </P> <BR> <P><FONT SIZE=3D2>Get FREE Email/Voicemail with 15MB at Lycos = Communications at <A HREF=3D"http://comm.lycos.com" =
 |
 |