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-2425046
053-4341500