What about
LOCK TABLE IN EXCLUSIVE MODE
then
TRUNCATE
then
commit .....
"Mike F" <u518615722_at_spawnkill.ip-mobilphone.net> wrote in message
news: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 - 12:57:03 CDT
