Prérequis

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

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

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

• CREATE ANY INDEX system privilege
• CREATE ANY OBJECT system privilege

You cannot create a text index when there are cursors opened with the WITH HOLD clause that use either statement or transaction snapshots.

You cannot create a text index on a regular view or a temporary table. You cannot create a text index on a materialized view that is disabled.

Contexte et remarques

Text indexes consume disk space and need to be refreshed. Create them only on the columns that are required to support your queries.

Creating more than one text index referencing a column can return unexpected results.