Creating a Text Configuration Using Interactive SQL

Create a text configuration to specify how TEXT indexes dependent on the text configuration process handle terms within the data.

Connect to the database as a user with CREATE TEXT CONFIGURATION or CREATE ANY TEXT CONFIGURATION or CREATE ANY OBJECT system privilege.
Execute a CREATE TEXT CONFIGURATION statement.

To create a text configuration object called myTxtConfig using the default_char text configuration object as a template:

CREATE TEXT CONFIGURATION myTxtConfig FROM default_char;