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 
| refresh-alteration

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

refresh-alteration : 
{ MANUAL REFRESH 
| AUTO REFRESH [ EVERY integer { MINUTES | HOURS } ] }

Parameters

Remarks

Once a text index is created, you cannot change it to, or from, IMMEDIATE REFRESH. If either of these changes is required, you must drop the text index and create it again.

To view text indexes and the text configuration objects they refer to, see Accessing text index information in the database.

Permissions

Must be the owner of the underlying table, or have DBA authority, or have REFERENCES permission.

This statement cannot be executed when there are cursors opened with the WITH HOLD clause that use either statement or transaction snapshots. See Snapshot isolation.

Side effects

Automatic commit

See also

• Full text search
• Text indexes
• SYSTEXTCONFIG system view
• CREATE TEXT CONFIGURATION statement
• ALTER TEXT CONFIGURATION statement
• DROP TEXT CONFIGURATION statement
• CREATE TEXT INDEX statement
• ALTER TEXT INDEX statement
• DROP TEXT INDEX statement
• REFRESH TEXT INDEX statement
• TRUNCATE TEXT INDEX statement

Standards and compatibility

Example

The first statement creates a text index, txt_index_manual, defining it as MANUAL REFRESH. The second statement alters the text index to refresh automatically every day. The third statement renames the text index to txt_index_daily.

CREATE TEXT INDEX txt_index_manual ON MarketingInformation ( Description ) 
   MANUAL REFRESH;
ALTER TEXT INDEX txt_index_manual ON MarketingInformation 
   AUTO REFRESH EVERY 24 HOURS;
ALTER TEXT INDEX txt_index_manual ON MarketingInformation 
   RENAME AS txt_index_daily;