Re: rollback segment for Designer 2000

"Don" <don_at_xxx.com> wrote in message
news:8a29stsnjq7djd244v08v9uqm3r7dfjmlu_at_4ax.com...
> On Wed, 10 Oct 2001 13:29:36 -0400, Don <don_at_xxx.com> wrote:
>
> >Installing rollback Designer 2000
> >on an Oracle8i 8.1.7 server
> >
> >
> >instructions say to create rollback segment in the
> >newly created "repository" tablespace
> >
> >but oracle will not allow this.....
> >
> >
> >only can be created in the RBS tablespace ....
> >
> >
> >
> >why ???????????
>

It is bad practice to have rollback segments in the same tablespace as your valuable data. If that data tablespace crashes, your rollback segment also crashes. As a rollback segment stores info about transactions in the database, so you potentially loose much more when you create a rollback segment in a data tablespace.

This must be a documentation bug

Regards,

Sybrand Bakker,

Senior Oracle DBA Received on Wed Oct 10 2001 - 20:13:18 CEST