Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00054: resource busy and acquire with NOWAIT specified

885842Oct 5 2012 — edited Oct 8 2012

Im running 2 updates in the same schema but to 2 completely different tables via sql loader.

Due to timing issues they sometimes run at the same time. However i keep getting error :

ORA-00054: resource busy and acquire with NOWAIT specified

When i look this error up it says its due to a lock on a table but they are different tables.

Any ideas?

Many thanks

This post has been answered by Mahesh Gholap on Oct 8 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2012

Added on Oct 5 2012

#general-database-discussions

7 comments

52,601 views