i'm having problems loading a thesaurus: begin ctx_thes.create_thesaurus('thesa', FALSE); end;
the thesaurus is created. Then I try to load it: begin ctxload -thes -name thesa -file 'C:\Users\Sara\Desktop\test.txt' end;
ORA-06550: line 2, column 10:
PLS-00103: Encountered the symbol "-" when expecting one of the following: := . ( @ % ;
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
if I try to load the thesaurus without the commands begin/end, occurs the error: unknown command
Does anybody know how can I load the thesaurus?
I see this is your first post, so welcome to the OTN forums and to the Oracle Text sub-forum.
Ctxload needs to be run from the operating system, not from SQL*Plus. Also, you need to include the user. Please see the following section of the online documentation for the proper syntax:
Also, the following section contains an example of the proper syntax:
The following thread on these forums contains an example of just using "ctxload -thes", then letting it prompt you for the additional parameters. It also demonstrates that using ctxload when the thesaurus already exists produces an error, so it needs to be dropped first, one way or another. This example is for the default thesaurus, but you can just change the name default to your own thesaurus. Thesaurus loading + DRG-11510: encountered unrecoverable error on line 1