Re: Rollback Segments Question

Tim X wrote:

> <snipped>
>
>
> Thanks for the feedback. This clarifies things for me. So, the second
> (temporary) rollback segment in the system tablspace is required if
> you want to create rollback segments on locally managed
> tablespaces. If you are not using LMT, then I gather you don't need
> this second RBS?
>

Correct

>
> What really had me confused here is that older Oracle documentation
> (pre 8.1.7) also states you need this requirement, but you did not
> have LMT back then (e.g. 7.3.4) - the DBAs where I work said it wasn't
> needed and they never use a temporary second rollback segment in their
> creation scripts.

Can't help you there. My memory isn't that good at my age.

> THis is what I like about this group. I find often Oracle docs state
> you need to do something, but don't give any reasoning as to why -
> just do it and don't ask. I find things a lot easier to rmember if I
> can understand why something is needed.
>
> Thanks,
>
> Tim
> --
> Tim Cross
> The e-mail address on this message is FALSE (obviously!). My real e-mail is
> to a company in Australia called rapttech and my login is tcross - if you
> really need to send mail, you should be able to work it out!

Happy to help.

Daniel Morgan Received on Tue Apr 08 2003 - 18:17:29 CDT