No. Leave it alone. Automatic means automatic. Oracle takes care of it.
It starts out with a small extent and as you add more data to that table the
extents get larger. The multiples that the extents get larger are sized
correctly to not have holes(that can't be filled) if tables are dropped.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Rogbaker" <Rogbaker_at_gdi.net> wrote in message
news:e40a12ea.0303200732.2055005a_at_posting.google.com...
> Oracle 8.1.7 on windows 2000:
> Tables that I create in a tablespace that is defined as "Locally
> Managed Extent Management" and has "Automatic Allocation" have a NEXT
> extent size set to 0 (zero) no matter what I try to set it to. What
> does this '0' mean exactly, is this bad? Should I be using Dictionary
> managed extent management?
> THanks,
> Roger
Received on Thu Mar 20 2003 - 10:29:07 CST
