DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: updates without rollback

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Posts
    143

    Question

    How do I run an update script without using a rollback segment.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    You simply can't!!! In some situation you can avoid writing transactions to redo logs, but you can't perform transactions without writing undo information to rollbacks.

    Undo information is written to rollback segment not just because you might decide to roll back the transaction, but because the database has to provide *read consistent view* for other users on the data you are changing during your transaction! The third reason for writing undo into rollback segs is the ability to perform instance recovery in case database crashes during your transaction.

    Bottom line: transactions allways cause undo information to be written to rollback segments, you can't avoid it.

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width