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
.
