Quote Originally Posted by nagarjuna
This makes the tablespaces LMTs and at the same time extent management remains as user.
Ummm...I may wrong on this, but once a segment is in a LMT, you can't control any of it's extent sizes. When you specify the EXTENT MANAGEMENT LOCAL clause, the default is AUTOALLOCATE (the other option is UNIFORM). But once AUTOALLOCATE or UNIFORM is specified, user has no more control over extents sizing.

This is how I've understood this to be. So I don't understand what you're talking about...