|
-
Try 'alter tablespace xxxxx coalesce ; as temporary solution.
And rebuild your indexes using the following dynamic sql script:
spool rbuildindx.sql
select 'alter index '||owner||'.'||segment_name||' rebuild;'
from dba_segments
where owner not in ('SYS','SYSTEM','DBSNMP')
-- where owner in ('TCOOLS','C_AFFAIRS')
and segment_type='INDEX' and extents > 2;
spool off
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
|