Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why two rollback segments in system tablespace to create other tablespaces?
Cheong,
If you plan on creating segments on tablespaces other than on the SYSTEM tablespace and doing any DML on it you must have a rollback segment other than the SYSTEM rollback segment otherwise Oracle will complain.
Clement
Cheong wrote:
>
> Surely someone could answer this question:
>
> Oracle7 Server SQL Reference says,
> "(The prerequisite to create tablespace is that) ... the SYSTEM tablespace
> must contain at least two rollback segments including the SYSTEM rollback
> segment.
>
> I tried creating other tablespaces with only one SYSTEM rollback segment. It
> works.
>
> I also tried creating other tablespaces with one SYSTEM rollback segment,
> one TMP rollback segment on SYSTEM tablespace. It works also.
>
> So why must there be "at least two rollback segments including the SYSTEM
> rollback segment" in order to create other non-system tablespaces?
>
> Cheong
Received on Thu Mar 25 1999 - 05:30:13 CST