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

    Unanswered: Rollback segment

    Hi friends,

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

    regards
    sudheer

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246

    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).
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

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