Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    Hong Kong
    Posts
    5

    Unanswered: undo tablespaces

    Just learn that the newly introduction in 9i about undo tablepace is recommended rather than rollback segment.

    What is the differenece between them?

  2. #2
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    Using Undo tablespaces allows you to take advantage of 'flashback'. This is a sort of rollback even after a commit.

    The other advantage is that Oracle handles all the undo management for you.

Posting Permissions

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