No. COMMIT is a transactional statement. In Oracle, readers do not block writers.
----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Mark Martin [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 24, 2004 9:26 AM To: Ronald J Kimball Cc: [EMAIL PROTECTED] Subject: RE: Why wont my script finish? Brilliant - that's it! Thank you! Would SELECTs lock up a record without a commit statement? Mark At 11:15 24/11/2004 -0500, Ronald J Kimball wrote: >Mark Martin [mailto:[EMAIL PROTECTED] wrote: > > > > 49620 rows deleted in ~ 15 seconds. > > ( I have tried the delete from DBI on varying subsets of data all the way > > down to 1 record (the only delete that works)) > > > >Might you have one of the rows you're trying to delete from DBI locked in >SQLPLUS? Make sure you commit in SQLPLUS to release any locks you're >holding. > >Ronald This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
