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

Parameters

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

move-object clause – Requires one of:
ALTER ANY INDEX system privilege.

ALTER ANY OBJECT system privilege.

REFERENCE permission on the underlying table.

You own the underlying table

rename-object clause – Requires one of:
ALTER ANY INDEX system privilege.

ALTER ANY OBJECT system privilege.

MANAGE ANY DBSPACE

One of the following:
You own the underlying table being indexed.

REFERENCE privilege on the table along with one of the following:
CREATE ANY OBJECT system privilege.

CREATE privilege on the target dbspace.