|Oracle8i interMedia Text Migration
Release 2 (8.1.6)
Part Number A77061-01
Indexing, 6 of 14
In pre-8.1, you drop preferences using CTX_DDL.DROP_PREFERENCE, and you can only do so when all referenced policies have been deleted from the data dictionary.
In 8.1, you drop index preferences with the same procedure CTX_DDL.DROP_PREFERENCE. Because preferences exist separately from the index and because policies do not exist in 8.1, you need not drop your index before you drop a preference.
Dropping a preference does not affect the index that is using the dropped preference.
To learn more about the syntax for the CTX_DDL.DROP_PREFERENCE procedure, see the Oracle8i interMedia Text Reference.
The following code drops the preference