Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help:ORA-00054: resource busy and acquire with NOWAIT specified

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

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Wed, 24 Apr 2002 19:40:18 GMT
Message-ID: <CSDx8.48484$QC1.3441174@bgtnsc04-news.ops.worldnet.att.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US