RE: Oracle cursor help

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:steves06@xxxxxxxxxxx]
Sent: Saturday, June 25, 2005 10:20 PM
Cc: dbi-users@xxxxxxxx
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 steves06@xxxxxxxxxxx

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.

.