Re: RollBack TableSpaces

In article <4uv61t$5kk_at_eng_ser1.erg.cuhk.hk>, s926058_at_sgiind09.csc.cuhk.hk (LUN WING SAN) writes:
>In previous article, Kevin J. Donovan (kdonovan_at_edgewater.com) wrote:
>[QUOTE]Help !
>
>[QUOTE]Im having some minor problems here; I have an oracle database that I
>[QUOTE]created, within this DB there is a default rollback tablespace created
>[QUOTE]by Oracle as well a RollBack segment that I have created. How do I
>[QUOTE]explicitly state for users in a database to use a particular rollback
>[QUOTE]table space in lieu of the default rollback tablespace ?
>
>
>The steps are as follows :
>1. create tablespace ts datafile 'xxx' size 50M
>2. create public rollback segment rs1 tablespace ts
> create public rollback segment rs2 tablespace ts
>3. specified the ROLLBACK_SEGMENTS parameter of the parameter file to
> ROLLBACK SEGMENTS=(rs1, rs2)
>4. restart the instance

You don't need to specify PUBLIC rollback segments in the parameter file. In fact, the parameter file is not consulted when dealing with public rollback segments. They are always allocated at database opening. They are only useful in parallel server situations, which are rare. Private rollback segments are far easier to manage. Received on Fri Aug 30 1996 - 00:00:00 CEST