ALTER TEXT INDEX Statement

Alters the definition of a TEXT index.

Syntax

ALTER TEXT INDEX [ owner.]text-index-name
  ON [ owner.]table-name
  alter-clause

alter-clause :
   rename-object | move-object

rename-object :
   RENAME { AS | TO } new-name

move-object:
   MOVE TO dbspace-name

Examples

– Create a TEXT index, MyTextIndex, defining it as IMMEDIATE REFRESH, rename the TEXT index to Text_index_daily, and move the TEXT index to a dbspace named tispace:
CREATE TEXT INDEX MyTextIndex ON Customers ( CompanyName ) IMMEDIATE REFRESH;

ALTER TEXT INDEX MyTextIndex ON Customers RENAME AS Text_index_daily;

ALTER TEXT INDEX Text_Index_Daily ON Customers MOVE TO tispace;

Usage
Use ALTER TEXT INDEX to rename or move the TEXT index.

RENAME clause – rename the TEXT index.

MOVE clause – move the TEXT index to the specified dbspace.

Side Effects:
Automatic commit.

Permissions
Must be the owner of the underlying table, or have DBA authority, or have REFERENCES permission to rename the index.

To move the TEXT index, you must have DBA or SPACE ADMIN authority, or you must be the table owner and have CREATE permission on the dbspace.