IOT Manitenance
In order to defrag a few IOTs in our system, we are planning to use "alter table
move".
Questions:
1/ Is "alter table move" an optimal way to defrag an Index Organized Table?
2/ All IOTs have constraints and triggers. What do we need to do to avoid any issues such as data corruption while running "alter table move"
3/ Can "alter table move" be done online?
Questions:
1/ Is "alter table move" an optimal way to defrag an Index Organized Table?
2/ All IOTs have constraints and triggers. What do we need to do to avoid any issues such as data corruption while running "alter table move"
3/ Can "alter table move" be done online?
0