Re: LMT and rollback segments

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 Mon Apr 23 2001 - 13:22:35 CDT