Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ROLLBACK tablespace needs media recovery when startup mount;
Kenneth C Stahl wrote:
> What I have always done during database creation is create an additional
> rollback segment in the SYSTEM tablespace
You don't need to create an additional RB seg in SYSTEM since 7.1 (I think). Just go ahead and create a tablespace and add rollback segs to it.
> and then go ahead and create a
> RBS tablespace for rollback segments, create additonal rollback segments
> there and then go back and take my extra rollback segment in the SYSTEM
> tablespace offline. That way if I ever want to drop the RBS tablespace I
> would just put my extra roolback segment back online, drop all of the
> rollback segments in the RBS tablespace and then drop the tablespace.
>
> Ken
>
--
Met vriendelijke groet/kind regards,
Frank van Bortel
Technical consultant Oracle
Work: Home: ---------------------------------- ---------------------------- V&L Informatica BV Hunzestraat 4 Palatijn 3, 7521 PN Enschede 7555 WB Hengelo PoBox 545, 7500 AM Enschede (31)074-2425046053-4341500 Received on Fri Aug 27 1999 - 13:12:13 CDT