ALTER TEXT INDEX Statement

Renames, moves or alters the definition of a TEXT index.

Note: This statement requires the Unstructured Data Analytics (IQ_UDA) license.

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

Parameters

RENAME – rename the TEXT index.

MOVE – move the TEXT index to the specified dbspace.

Examples

Example – creates 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

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.