Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help:ORA-00054: resource busy and acquire with NOWAIT specified
To be more documentary for junior DBAs or programmers who might have
occasion later on to look at or maintain the code, and don't know , or
forgot, that because TRUNCATE is a DDL command and thus implicitly commits,
an explicit commit is not necessary?
RSH.
"Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message
news:3CC6F49C.D508F5FE_at_exesolutions.com...
> 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 - 14:40:18 CDT