Dropping a text configuration

Remove an unnecessary text configuration from the database. Only text configurations that are not being used by a TEXT index can be dropped.

1. Connect to the database as a user with DBA or RESOURCE authority.

2. In the left pane, select Text Configurations Objects.

3. In the list of Text Configurations, right-click the object to modify and select Delete.

4. In the confirmation dialog, click Yes.

1. Connect to the database as a user with DBA or RESOURCE authority.

2. Execute a DROP TEXT CONFIGURATION statement.

   For example, to drops a text configuration object called myTxtConfig, use:

   DROP TEXT CONFIGURATION myTxtConfig;