Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    Unanswered: Does this sound right? UNDO tablespace

    Does this sound right?
    UNDO replaces Rollback in Oracle. Instead of several Rollback files, you create one UNDO tablespace with several datafiles. Undo does the same functions that Rollback did.
    Michellea Southern-David

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: Does this sound right? UNDO tablespace

    Originally posted by msouthern
    Does this sound right?
    UNDO replaces Rollback in Oracle. Instead of several Rollback files, you create one UNDO tablespace with several datafiles. Undo does the same functions that Rollback did.
    YES

  3. #3
    Join Date
    Sep 2003
    Location
    CA
    Posts
    38

    Re: aren't rollback 'n undo doin' the same job?

    I don't know much 'coz even am a beginner with Oracle but doesn't the UNDO 'n Rollback sound the same 'coz even Rollback is like rollback files managed in a rollback tablespace......or is this sth. different from some special type of UNDO tablespace?
    Pooja

    Originally posted by anacedent
    YES

  4. #4
    Join Date
    Apr 2003
    Location
    Los Alamos/Santa Fe, NM
    Posts
    69

    Rollback

    I thought Rollbacks were each in an individual datafile, no tablespace to manage them. Maybe I am wrong?
    Michellea Southern-David

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    With Oracle 9i, there are not longer "ROLLBACK SEGMENTS" as
    we know them ... They are now managed in an UNDO tablespace

    Gregg

Posting Permissions

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