Alters the definition of a TEXT index.
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
In this example, the first statement creates a TEXT index, MyTextIndex, defining it as IMMEDIATE REFRESH. The second statement renames the TEXT index to Text_index_daily. The third statement moves it 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;
RENAME clause Rename the TEXT index.
MOVE clause Moves the TEXT index to the specified dbspace.
Automatic commit.
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.
