Re: LMT and rollback segments

You also can't use autoallocate. For rollback segments you need to use uniform size.

Stephen Bell wrote:
>
> Hi Peter,
> It's not so much a question of interaction with rollback segments as a
> question of locally managed tablespaces in general. If you specify a
> tablespace as a locally managed tablespace (i.e. specify ''local" in he
> create tablespace command) you cannot specify a default storage clause.
>
> Hth,
>
> Steve
>
> Peter Laursen wrote:
>
> > Maybee a naive question, anyway here goes
> >
> > How does the Locally Managed Tablespace feature interact with rollback
> > segments?
> >
> > Say rbs is a LMT with autoallocate and I do
> > create rollback segment rbs1
> > tablespace rbs
> > storage(initial 1m next 1m minextents 15 maxextents 500);
> > will this storage clause actually be used?
> >
> > TIA
> > Peter Laursen
Received on Fri Apr 27 2001 - 18:25:31 CDT