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.

--
Steve Sapovits  [EMAIL PROTECTED]

Reply via email to