Dropping a Preference

Pre-8.1

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.

8.1

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.

See Also: To learn more about the syntax for the CTX_DDL.DROP_PREFERENCE procedure, see the Oracle8i interMedia Text Reference.

Example

The following code drops the preference my_lexer.

begin
ctx_ddl.drop_preference('my_lexer');
end;