-
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';
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|