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

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