insert / delete locking conflict

From: Jeffrey Tristram Colket <jtc_at_acpub.duke.edu>
Date: Thu, 23 Apr 1998 15:55:46 -0400
Message-ID: <Pine.SOL.3.91.980423155019.20905A-100000@godzilla5.acpub.duke.edu>

I am experiencing a lock on a table when trying to insert from one Oracle session while another Oracle session is deleting from the table (the delete is actually propogated from a cascade delete but I have the columns of the foreign key indexed so there are no table level locks preventing the insert). Any ideas why I would be getting a row level lock or something similar preventing the insert? Any help would be greatly appreciated.

Thanks,
Jeff Colket Received on Thu Apr 23 1998 - 14:55:46 CDT