Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00054: resource busy and acquire with NOWAIT specified(Error) (Oracle 10g,10.2.0.1,Solaris)
ORA-00054: resource busy and acquire with NOWAIT specified(Error) [message #284095] Wed, 28 November 2007 18:17 Go to next message
sheker2007
Messages: 19
Registered: November 2007
Junior Member
Hi All,

I have one table(range partitioned) on date column(month by month partition).
2 persons can work on same table same time.For ex : one can work on current month partition and do truncate data other can query on previous month partition.(Or reverse way).At that time we are getting below error :

ORA-00054: resource busy and acquire with NOWAIT specified

Any idea...,need help.

Thanks in advance.
Sheker
Re: ORA-00054: resource busy and acquire with NOWAIT specified(Error) [message #284096 is a reply to message #284095] Wed, 28 November 2007 18:25 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Any idea...,need help.
Yes, two folks should NOT be doing DDL against same table at same time.
Re: ORA-00054: resource busy and acquire with NOWAIT specified(Error) [message #284097 is a reply to message #284096] Wed, 28 November 2007 19:11 Go to previous messageGo to next message
sheker2007
Messages: 19
Registered: November 2007
Junior Member
Both are not doing DDL.One person doing DDL on one partition.
Other one selecting data from other partition.
Re: ORA-00054: resource busy and acquire with NOWAIT specified(Error) [message #284100 is a reply to message #284095] Wed, 28 November 2007 19:37 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
In some/many/most/all cases DDL requires exclusive lock against object.
The simple fact that you are getting an ORA-00054 error means Oracle is preventing you from doing what you want to do.

Please accept that reality.
Re: ORA-00054: resource busy and acquire with NOWAIT specified(Error) [message #284142 is a reply to message #284095] Thu, 29 November 2007 00:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Truncating a partition requires an exclusive lock on the whole table, during a very short time but it requires it.

Regards
Michel
Re: ORA-00054: resource busy and acquire with NOWAIT specified(Error) [message #284291 is a reply to message #284095] Thu, 29 November 2007 05:48 Go to previous message
sheker2007
Messages: 19
Registered: November 2007
Junior Member
Thank you Michel.
Previous Topic: qry help plz ... (merged similar topics by same user)
Next Topic: PIVOT QUERY NOT WORKING PLEASE HELP
Goto Forum:
  


Current Time: Fri Dec 02 16:53:37 CST 2016

Total time taken to generate the page: 0.18579 seconds