|
-
Netbar,
Yes I have moved tables and partitions and rebuild partitioned indexes.
Point off caution could be that if you move a table (or table partition) the index(es) will be getting the status unusable.
A strategy can be:
- move the small tables first using a small initial extent size
- rebuild the unusable indexes with a smal initial
- move the medium size tables/partitions
- rebuild the unusable indexes
and so on.
Don't start with rebuilding all your indexes and later move the tables because you have to rebuild them again.
HTH,
Tycho
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
|