|Oracle8i interMedia Text Migration
Release 2 (8.1.6)
Part Number A77061-01
Indexing, 7 of 14
In pre-8.1, you drop an index using CTX_DDL.DROP_INDEX.
In 8.1, you drop an index using the DROP INDEX command in SQL.
For example, to drop an index called
newsindex, issue the following SQL command:
If Oracle cannot determine the state of the index, for example as a result of an indexing crash, you cannot drop the index as described above. Instead use:
To learn more about the DROP INDEX command syntax, see the Oracle8i interMedia Text Reference.