Altering a Text Configuration Using Interactive SQL

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.

Connect to the database as a user with ALTER ANY TEXT CONFIGURATION or ALTER ANY OBJECT system privilege, or as the owner of the text configuration object.
Execute an ALTER TEXT CONFIGURATION statement.

To alter the minimum term length for the myTxtConfig text configuration object:

ALTER TEXT CONFIGURATION myTxtConfig 
	MINIMUM TERM LENGTH 2;