Adding 2nd rollback segment

From: Rick Poepping <rickp_at_crl.com>
Date: 1996/01/29
Message-ID: <4eiqsf$ck6_at_crl.crl.com>#1/1


Has Oracle changed the requirement that you have to add a 2nd rbs to the system tablespace before being able to add additional rbs in their own tablespace??? I know this used to be the case back in 7.0.16. I had heard that it was no longer true in 7.2.2. So I tried it out. Took already existing database with extra rbs exisiting outside system tspace; deleted these, tried to recreate and it worked. Did same again, this time bouncing the database before trying to recreate, still successful. Couldn't find anything in docs or release notes. Thought I'd try this on one of our 7.1.6 databases. Successful again. Is this really indicatine of a change?? Or is the fact that I went through the 'add 2nd system rbs, now add outside rbs, then del 2nd system rbs, and go merrily on your way' effort to set up the outside rbs before trying this test, coloring my results? I'd like to know if anyone has confirmation that the ol' 2nd system rbs shuffle is no longer necessary. Has anyone added additional rbs outside the system tspace on a newly created database without first haveing to add a 2nd rollback segment in the system tablespace. I guess I could try this myself but I'd rather have one of you tell me :).

Thanks,

Rick

-- 
Rick Poepping                                          Just my Opinions.
St. Louis, MO USA                                      Keep it Simple.
rickp_at_crl.com                                          Friend of Bill W.
Received on Mon Jan 29 1996 - 00:00:00 CET

Original text of this message