Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Removes a text index from the database.
DROP TEXT INDEX text-index-name ON [ owner.]table-name
Use this clause to specify the table or materialized view on which the text index was built.
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.
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:
Not in the standard.
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;