At 09:38 24/11/2004 -0700, Reidy, Ron wrote:
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.
