Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT
ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT [message #662300] Mon, 24 April 2017 05:02 Go to next message
mskphani
Messages: 5
Registered: March 2016
Junior Member
Hello,

I have a tables gp_items,gp_projection partitioned based on country code. I am executing a process which will truncate the table based on partition and insert the date. When I am executing a process in parallel for all countires I am receiving the error ora-00054.TRUNCATE GP_ITEMS AND GP_PROJECTION TABLE STEP 0 ERROR. Could you please let me know how to avoid this error ?

thanks
Siva M
Re: ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT [message #662301 is a reply to message #662300] Mon, 24 April 2017 05:05 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Check nothing is locking the object before you try and truncate it, which requires an exclusive lock.
Re: ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT [message #662302 is a reply to message #662301] Mon, 24 April 2017 05:12 Go to previous messageGo to next message
mskphani
Messages: 5
Registered: March 2016
Junior Member
Hello Roachcoach,

Thanks for your reply. I am truncating the partition. If I insert the data in another partition at the same time will it lock the table until the transaction is committed ?
Re: ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT [message #662303 is a reply to message #662302] Mon, 24 April 2017 05:15 Go to previous messageGo to next message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
Test it, best way to learn Smile
Re: ORA-00054 RESOURCE BUSY AND ACQUIRE WITH NOWAIT [message #662311 is a reply to message #662303] Mon, 24 April 2017 10:50 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

... and feedback in your topics if you want to still have help.

Previous Topic: Taking Sum of Similar Tables
Next Topic: PLS-00497: cannot mix between single row and multi-row (BULK) in
Goto Forum:
  


Current Time: Thu Mar 28 21:37:26 CDT 2024