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.

Quick Links:

Syntax

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

alter-clause - (back to Syntax)
   rename-object | move-object 

rename-object - (back to alter-clause)
   RENAME { AS | TO } new-name

move-object - (back to alter-clause)
   MOVE TO dbspace-name

Parameters

(back to top)

RENAME – rename the TEXT index.

MOVE – move the TEXT index to the specified dbspace.

Examples

(back to top)

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

(back to top)

Side Effects:

Automatic commit.

Permissions

(back to top)

move-object clause – Requires one of:

ALTER ANY INDEX system privilege.
ALTER ANY OBJECT system privilege.
REFERENCES privilege 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.
- REFERENCES privilege on the table along with one of the following:
  - CREATE ANY OBJECT system privilege.
  - CREATE privilege on the target dbspace.