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.
Steve Sapovits wrote:
Feeling all confident, I fired up a DELETE/WHERE from SQL*Plus directly,
only to get a weekend call at my nephew's graduation party. Seems I had
used a ton of rollback and created some very angry DBA's. I know the
query
is okay (very simple WHERE clause) because I was able to select rows
using
it in a reasonable amount of time. Does the rollback issue disappear if
you set auto-commit on? I would think so but a web search made me not so
sure. Seems silly that you can't delete rows without an act of Congress.