 |
-
From the navigation pad, select Tools >Text Management >
Text Index. The Text Index page appears.
-
Select a language and its territory from the respective
lists.
-
Select the Class Label
or Class Name.
A list of Class Label or Class Name appears.
-
Select a class for which the Text Indexes are to be
created.
This table explains the list of eligible properties:
Properties |
Description |
Property Label |
The name of the Class
Property to be indexed. |
Property DB Name |
The DB name of the Class
Property to be indexed. |
Data Type |
The data type of the
Class Property. This can be:
|
Length |
The length of Class
Property to be indexed. |
Is Indexed |
Indicates if the Text
Index already exists for the Class Property. |
-
Select a class property from the list and click Create.
The Text Index is created, following which:
Log file, cr_ctx_index_<ORACLE_SID>.log is created in the
log directory. Check this log file for possible error messages. The
following error messages are defined for this process:
- Class DB Name not found.
- Class Property DB Name not found.
- Class Property's datatype is invalid to create a Text Index.
- Length of Class Property must be greater than 4 characters.
- The tablespace CISCTX_INDEX_SPACE does not exist.
 |
If a Text Index is not created successfully, it is marked as created
internally by
Oracle. But the index cannot be used or altered. In such cases, you need
to
drop the Text Index and re-create it. |
|