Oracle Text (Error Ora-29833)

[Luiz Marini]

Does anyone here use Oracle 10G for Text Mining applications?
is the following: I need to create a ctxrule type index and the following error:

Select all

'ORA-29833: o tipo de índice não existe'.

I read in the 'Oracle Text Application Developer's Guide Guide that Oracle 10g supports text text applications, but I do not know if you need to set up some specific parameter.
The script is as follows:

Select all

CREATE INDEX queryx ON myqueries(query) 
INDEXTYPE IS CTXRULE PARAMETERS 
('lexer lexer_pref 
storage storage_pref 
section group section_pref 
wordlist wordlist_pref');

If someone knows something I thank!

[stcoutinho]

Luiz,

I am responding to this old topic open to the case of a forista come across this problem.

In OTN Oracle forums, they make some recommendations on this type of error:
a) Make sure that at your base there is the CTXSYS schema created. If you do not exist, call DBAssistant and add this feature to your database;
(b) If there is, seek to name this schema in the creation syntax of your index. Example:

Select all

CREATE INDEX queryx ON myqueries(query) 
INDEXTYPE IS CTXSYS.CTXRULE  
PARAMETERS 
('lexer lexer_pref 
storage storage_pref 
section group section_pref 
wordlist wordlist_pref');

Hugs,

Sergio Coutinho