Modifying the location

Change the dbspace where the TEXT index is stored.

1. Connect to the database as a user with DBA or SPACE ADMIN authority or as table owner with CREATE privilege on dbspace.

2. In the left pane, select the Text Indexes folder.

3. In the list of Text Indexes, right-click the object to modify and select Properties.

4. On the General tab, select the dbspace from the drop-down list.

5. When the dbspace is updated, click OK.

1. Connect to the database as a user with DBA or SPACE ADMIN authority.

2. Execute a ALTER TEXT INDEX statement with the MOVE TO clause

   For example, to move the TEXT index MyTextIndex to a dbspace named tispace, enter:

   ALTER TEXT INDEX MyTextIndex ON 
   	GROUPO.customers MOVE TO tispace;