Originally posted by pando
well I think we have some missunderstandings, I thought you was saying SYSTEM tablespace but it seems that you meant AUTOALLOCATE?
Yes, earlier i had suggested, if you read the thread, to use SYSTEM managed Temporary tablespaces ie autoallocate.

But while testing i saw that each and every extent was 1M in size for the Teporary LMT even if uniform size is not mentioned.

While for a permanent tablespace even if you do not mention uniform size or autoallocate clause in create tablespace command it creates a system managed LMT.

So i thought i would rectify my suggestions