UNDOTBS1 vs ROLLBACK SEGS
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: UNDOTBS1 vs ROLLBACK SEGS

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    UNDOTBS1 vs ROLLBACK SEGS

    To all The 9i Gurus
    New to 9i. just need a clarification on a point. Created 9i database and imported all my 8i data into it.

    undo_management=AUTO
    undo_retention=10800
    undo_tablespace=UNDOTBS1

    QUESTION
    RBS is replaced by UNDOTBS1. Do i need to create another rollback segments tablespace?
    If I do could you say why
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Oct 2003
    Posts
    312
    no, you don't have to

  3. #3
    Join Date
    May 2001
    Posts
    73
    Nope.
    OCP 7.3,8.0,8i,9i

  4. #4
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372
    Thanks to all.
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: UNDOTBS1 vs ROLLBACK SEGS

    Originally posted by Ablakios

    QUESTION
    RBS is replaced by UNDOTBS1. Do i need to create another rollback segments tablespace?
    If I do could you say why
    RBS TS is *not* replaced with UNDO TS. You can still create a RBS TS if you want.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  6. #6
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: Re: UNDOTBS1 vs ROLLBACK SEGS

    Originally posted by julian
    RBS TS is *not* replaced with UNDO TS. You can still create a RBS TS if you want.
    [Deep breath, "no stupid questions", sticks out head . . . ] Why might I want to?

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Re: Re: UNDOTBS1 vs ROLLBACK SEGS

    Originally posted by DaPi
    [Deep breath, "no stupid questions", sticks out head . . . ] Why might I want to?
    Beats me. You might be really devoted to the concept :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    [relieved sigh . . . ] For a moment I thought I'd "lost it".

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by DaPi
    [relieved sigh . . . ] For a moment I thought I'd "lost it".
    4.5 version of SAP does not support UNDO_TABLESPACES, you must use RBSs if your database is 9i. It doesn't support pga_aggregate_target either.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  10. #10
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    By setting undo_suppress_errors = true, oracle ignores the specific RBS setting by the application. This is a good parameter, when many 3rd party applications do not allow to change their code.

    Tamil

Posting Permissions

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



Click Here to Expand Forum to Full Width