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

Commit after a truncate? Why?

Daniel Morgan

Telemachus wrote:

> 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 - 13:08:46 CDT