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
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';
Click Here to Expand Forum to Full Width