Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Unanswered: Rollback segment

    Hi friends,

    Can I use both rollback and undo segment in a single database?
    Pls explain


  2. #2
    Join Date
    Sep 2003
    Virginia, USA

    Re: Rollback segment

    No, you cannot use both rollback and undo in the same database at the same time. If you want to know why, please read the Oracle9i Database Administrator's guide.

    You can have undo and rollback segments and tablespaces in the same database, or migration between them would not be possible. However, only one can be active at a time.

    You determine which will be used before starting the database, by setting the undo management parameter to either manual (for rbs) or auto (for undo).
    Author, Oracle Database 10g: From Nuts to Soup

Posting Permissions

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