Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Allocation type column in DBA_TABLESPACES
On Dec 10, 8:56 am, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> fitzjarr..._at_cox.net schrieb:
>
>
>
>
>
> > 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
>
> According to Note 182679.1 , your suggestion is correct (plus migrated
> tablespaces).
>
> Best regards
>
> Maxim- Hide quoted text -
>
> - Show quoted text -
Thank you for the Metalink reference.
David Fitzjarrell Received on Mon Dec 10 2007 - 09:41:44 CST