Prérequis

To alter a text index on a table, you must be the owner of the table or have one of the following privileges:

• ALTER ANY INDEX system privilege
• ALTER ANY OBJECT system privilege
• REFERENCES privilege on the table and either the COMMENT ANY OBJECT system privilege, the CREATE ANY INDEX system privilege, or the CREATE ANY OBJECT system privilege

To alter a text index on a materialized view, you must be the owner of the materialized view or have one of the following privileges:

• ALTER ANY INDEX system privilege
• ALTER ANY OBJECT system privilege

You cannot alter a text index to refer to a different text configuration object. If you want a text index to refer to another text configuration object, drop the text index and recreate it specifying the new text configuration object.

You cannot change a text index to, or from, IMMEDIATE REFRESH; to make this change, you must drop the text index and recreate it.