Why don't you speak with the DBAs at your site? They can tell you what they want, and if it goes south, they will have themselves to blame.
----------------- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Steve Sapovits [mailto:[EMAIL PROTECTED] Sent: Saturday, June 25, 2005 10:20 PM Cc: [email protected] Subject: Re: Oracle cursor help jeff wrote: > The rollback issue will not disappear. IIRC, Autocommit simply issues > a commit at the end of the transaction (delete) without you having to do > it explicitly. So that makes the simple DELETE/WHERE method of deleting rows no good for large row sets where rollback space is limited, correct? I guess next best is to try one of the other methods: Break it into deletes of smaller row sets or create a new table from a query and replace the old with the new. -- Steve Sapovits [EMAIL PROTECTED] 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.
