DROP TEXT INDEX statement

Removes a text index from the database.

Syntax

DROP TEXT INDEX text-index-name 
ON [ owner.]table-name

Parameters

ON clause
Use this clause to specify the table or materialized view on which the text index was built.

Remarks

You must drop dependent text indexes before you can drop a text configuration object.

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

Privileges

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

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

Side effects

Automatic commit

Standards

Example

The following statements create and drop the TextIdx text index:

CREATE TEXT INDEX TextIdx ON GROUPO.MarketingInformation ( Description )
DROP TEXT INDEX TextIdx ON GROUPO.MarketingInformation;