This content has been marked as final. Show 4 replies
To perform some clean up, I need to move some segments (from 1-4 GB) from one tablespace to another tablespace and then back to the original tablespace.
To avoid inter-dependencies, I intend to perform with this sequence:
- subpartition tables
- partition tables
- partition indexes
When finish, rebuild online the unusable/invalid indexes.
If you have such experience, can you tell me if it is a good approach?
Thanks and Regards