Saturday, May 19, 2018

Re-organization Activity

Re-organization Activity


Reorganization is very useful in order to reduce space used by blocks and it also helps in improving the performance of the Oracle Database. It also helps to reduce the fragmentation.

There are 3 ways to do re-organization activity:

1.Export/Import.
2.Alter table Move.
3.CTAS method.


No comments:

Post a Comment