Altering a text configuration

Change the settings of the text configuration object, including the dbspace and permitted term lengths range. You can alter only text configuration objects that are not being used by a TEXT index.

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 Properties.

4. Switch to the Settings tab, and modify the settings as needed.

5. Click OK.

1. Connect to the database as a user with DBA or RESOURCE authority, or as the owner of the text configuration object.

2. Execute an ALTER TEXT CONFIGURATION statement.

   For example, to alter the minimum term length for the myTxtConfig text configuration object, use:

   ALTER TEXT CONFIGURATION myTxtConfig 
   	MINIMUM TERM LENGTH 2;