I'm getting this error
ORA-00054: resource busy and acquire with NOWAIT specified
How do I overcome this ?
While doing what ? you are getting error ? whats the situation?
If you are trying to load the data and do get this error, you can get rid of it by setting up commit parameter say for every 10000 rows or so.
I'm getting this error when I'm trying to truncate a table.
The usual reason for this error is that someone else has an open transaction on this table. For example, they (or possibly you) has that table up on their screen from some application or utility. Something like SQL-Stations maybe where they can update a record and it doesn't automatically commit.
Check the SGA for any open cursors that reference that table.
I had the same problem couple of weeks ago, Lets Analyze my situation when I was loading the data, steps are as follows:
3.load data into table
In 2nd step (say Session S1) DDL statements ALTER,DROP and TRUNCATE statements locks the table.
3rd step (say Session S2) locks the table for insert.
Hence the ALTER statement in S1 is blocked by S2 lock. Until S2 commits its INSERT and release the lock S1 can't complete its task.
so by mentioning commit=99999 (say no. of rows) the problem will be resolved.
I wasdoing an insert prior to the truncate command on that table. How do I do the commit ?
How are you inserting ? thru script/sql*loader ? explicitely commit after inserting say 10000 rows or so...
Click Here to Expand Forum to Full Width