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!

SQL Loader lock

677929Apr 22 2009 — edited Apr 23 2009

Hi,

We are loading a table using direct path SQL Loader. The data will be loaded in to one partition. While the load is running we are trying to TRUNCATE another partition. But the TRUNCATE will cause an ORA-00054: Resource busy and acquire with NOWAIT specified.

It seems that the load takes a shared lock on that specific table. Which prevent the TRUNCATE.

Is it possible to prevent the load to take a lock on table level? Any other suggestion how to run this two parallel?

Regards
David

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2009

Added on Apr 22 2009

#general-database-discussions

3 comments

1,149 views