Modifying the TEXT Index Location Using Interactive SQL

Change the dbspace where the TEXT index is stored.

1. Connect to the database as a user with MANAGE ANY DBSPACE system privilege.
2. Execute an ALTER TEXT INDEX statement with the MOVE TO clause.

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