Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00054: resource busy and acquire with NOWAIT specified

RE: ORA-00054: resource busy and acquire with NOWAIT specified

From: Michael Kline <maklinesr_at_home.com>
Date: Mon, 8 May 2000 13:54:11 -0400
Message-Id: <10491.105184@fatcity.com>


When I know the action will be quick, I use the following, and yes, this one will wait forever, so I submit it to background if it's unix.

lock table xxx in exclusive mode;
alter index XXX storage ( next 2147467264 ); commit;
exit;

this will wait till the table is mine, do the 1-5 second operation, and release the table. I've done this on a 24x7 operation many times. It IS a good idea to still schedule this "after hours" or at a point most likely to be as "quiet" as possible.  

Database Consultants, Inc. - Michael Alan Kline, Sr. Technical Consultant - Richmond, Virginia Office 13308 Thornridge Court; Midlothian, VA 23112, USA. W: 804-744-1545
Michael_Kline_at_databaseconsultants.com
<mailto:Michael_Kline_at_databaseconsultants-corp.com> Pager: 877-705-1155 or 8777051155_at_mobile.att.net <mailto:8777051155_at_mobile.att.net>
ICQ: 1009605, 975313 PhoneFree: 1057439

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Martin,
> Alan
> Sent: Monday, May 08, 2000 1:47 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-00054: resource busy and acquire with NOWAIT specified
>
>
> Can you actually cause the following statement to WAIT? If so,
> will it WAIT
> forever?
>
> alter index XXX storage ( next 2147467264 )
> *
> ERROR at line 1:
> ORA-00054: resource busy and acquire with NOWAIT specified
>
> Thanks,
> Alan Martin
> GMAC Insurance
> Winston-Salem, NC
> --
> Author: Martin, Alan
Received on Mon May 08 2000 - 12:54:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US