Re: rollback segment question

stef wrote:

> Hi, everybody
>
> I'm a newbie in Oracle :) and I would like to know one thing
>
> When you create a rollback segment, is it possible to "assign" the segment
> to a specific
> data tablespace..? like Sybase or sql server do.
>
> example:
> In the same database "TEST_DB" :
> 1) create a data tablespace "datas_01".
> 2) create a second data tablespace "datas_02".
> 3) then create a rbs called "global_rbs" (mapping on a tablespace YYYY, not
> important )
>
> Now, as I can see, all datas_01 and datas_02 will "use" the same global_rbs
> ok...
> Can I say now, datas_01 use only global_rbs and datas_02 use... another rbs
> for example ?
>
> thanx....

You can assign to a specific tablespace ... you have to ... their is no other choice. But you can not assign to a specific user or schema.

Daniel Morgan Received on Sun Aug 11 2002 - 09:14:17 CDT