This procedure is designed to move data from a source table to a target table with a minimal impact to application access. The changes that can be made using ADMIN_MOVE_TABLE () are as follows:
- The table can be moved from the current data, index and long to a new set of table spaces, which could have a different page size, extent size, or type of table space management (something like moving data from SMS to an automatic storage table space).
- Enabling the compression or changing the compression type from static to adaptive or vice-versa can be implemented during the move.
- MDC clustering can be added or changed using a new ORGANIZE BY DIMENSION clause.
- Alter ITC tables using the ORGANIZE BY INSERT ...
