Re: Allocation type column in DBA_TABLESPACES

On Dec 10, 8:05 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> When I browsed through the reference manual, I noticed that the
> allocation type can have the following values: SYSTEM,UNIFORM and USER-
> SYSTEM is "EXTENT MANAGEMENT LOCAL AUTOALLOCATE". UNIFORM is, of course,
> EXTENT MANAGEMENT LOCAL UNIFORM SIZE <size>. What the heck is "USER"?
> I'd like a pointer to the appropriate document, if possible.
> TIA
>
> --
> Mladen Gogala

Although I can't find it in the documentation at the moment I believe USER would be referring to a dictionary-managed tablespace/object using the INITIAL, NEXT and PCTINCREASE storage parameters.

David Fitzjarrell Received on Mon Dec 10 2007 - 08:19:23 CST