|
-
[QUOTE][i]Originally posted by SANJAY_G [/i]
[B]Rebuild your indexes to another tablespace,
ALTER INDEX index_name REBUILD tablesapce_name;
Hope this helps.
Sanjay [/B][/QUOTE]
Hi Sanjay
The script that I run to move the indexes actually does what you suggest above.
After doing this when I try to resize the TS to a smaller size I hit ORA-03297:file contains XXX blocks of data beyond resize value.
Best regards
/Ashiq
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
|