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

From: Mike F <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Wed, 24 Apr 2002 16:23:02 GMT
Message-ID: <l.1019665383.1666015625@[64.94.198.252]>

One of our perl script, which will truncate all the tables belonging to perlstat at the middle of night, will fail with the following error messages:

ORA-00054: resource busy and acquire with NOWAIT specified

Because the targetted tables belonging to statspack was inserted every minuter by perfstat.snapshot.

How could I change the code so that instead of let the application fail, it will wait until the lock is released and then truncate the table? In other words, how could I turn off the NOWAIT on a table?

Thanks for your help

-- 
Sent  by dbadba62 from hotmail subpart  from com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new

Received on Wed Apr 24 2002 - 11:23:02 CDT