MOVE_INDEX

The MOVE_INDEX administration method moves an existing object type index from one tablespace or segment to another.

The MOVE_INDEX method returns TRUE if the operation succeeds or FALSE if it fails.

You must have system administrator or superuser privileges to run the MOVE_INDEX administration method.

To run the MOVE_INDEX administration method:

  1. Navigate to Administration > Job Management > Administration Methods.

    The system displays the Administration Methods list page.

  2. Click MOVE_INDEX.

    The system displays the Parameters page.

  3. Select an index from the Index Name drop-down list.

  4. Select the index space to which you want to move the index.

  5. Click Run.

    The method runs and the results are displayed.

  6. Click Close.

    The system displays the Administration Methods list page.