Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore
    Posts
    6

    Unanswered: Undo And Rollback

    CAN ANYBODY TELL HOW THESE BOTH WORK AND HOW THEY DIFFER ffrom each other

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    same thing.

    UNDO = 9i and above

    rollback = lower than 9i (but you can use rollback instead of
    UNDO in 9i even though it is not recomended)

    UNDO turns rollbacks segments into auto-management (kind of).
    You only need one UNDO tablespace which you can assign multiple
    datafiles to.
    Also, you can use the FLASHBACK option with UNDO which means you
    can retrieve committed deleted data. You cannot do this using rollback segments.

    All-in-all, once you start using UNDO you almost never have to worry
    about it (assuming you set to auto-extend or leave enough segment space in the UNDO)
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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