When you convert from dictionary to local, then you
will see the USER allocation type - because all of the
segments that already exist in the tablespace.
You also need to be careful when converting that you
have a reasonable size for common denominator of all
extents. If you had (for example)
How does one convert a tablespace from dictionary to
local? I've wanted to do the reverse but I never saw
anything in the docs that said this was an option.
Are you saying then, that this is probably what
happened in my case and now the tablespace is
performing extent management based on 8k
I seem to be confused about the relationship between
tablespace management and allocation methods.
What is the USER allocation_type (as reported by
DBA_TABLESPACES)? I thought this corresponded only to
dictionary-managed tablespaces--I see it associated
with locally-managed tablespaces as well.
Title: RE: Tablespace Allocation Type Extent Management
-Original Message-
From: Walter K [mailto:[EMAIL PROTECTED]]
I seem to be confused about the relationship between
tablespace management and allocation methods.
What is the USER allocation_type (as reported
