how to reduce table size?
Hello,
I am wanting to reduce the table size for optimizing I/O calls and space utilization.
My goal is to be able to do it completely online.
The table and tablespace has Manual Segment Space Management configured and moving it for right now is not possible.
Using ALTER TABLE .. MOVE; would invalidate all the indexes and doing so would make several queries practically unusable.
Is using Online Redefinition the best option for this scenario?
If you have feedback on using other methods that would be great, and keeping everything working is my main objective while I do this maintenance.
I am wanting to reduce the table size for optimizing I/O calls and space utilization.
My goal is to be able to do it completely online.
The table and tablespace has Manual Segment Space Management configured and moving it for right now is not possible.
Using ALTER TABLE .. MOVE; would invalidate all the indexes and doing so would make several queries practically unusable.
Is using Online Redefinition the best option for this scenario?
If you have feedback on using other methods that would be great, and keeping everything working is my main objective while I do this maintenance.
1