Extent Management

Yes, but even with DICTIONARY managed tablespaces INITIAL could equal NEXT. Even with LOCALLY managed tablespaces INITIAL doesn't always have to equal NEXT.

but if initial = next then you dont really have a major problem and space will be re-used

and no in an LMT they dont have to match - but then you know that it was created properly in the first place. If looking at an old DMt i'd definitely look there

i think the answer which sums this all up is move all the objects as you said anyway.

Thats the only way you get all the benefits

Thanks ebrian

It works :

select a.owner, a.segment_name, a.segment_type
from dba_segments a, dba_tablespaces b
where a.tablespace_name = b.tablespace_name
and b.extent_management = 'LOCAL'
and b.allocation_type = 'USER';