This discussion is archived
3 Replies Latest reply: Mar 7, 2013 10:35 AM by 994732 RSS

load Thesaurus

994732 Newbie
Currently Being Moderated
Hi,

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?

Thank you!

Best regards
Sara
  • 1. Re: load Thesaurus
    Barbara Boehmer Oracle ACE
    Currently Being Moderated
    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:

    http://docs.oracle.com/cd/E11882_01/text.112/e24436/cexec.htm#CCREF2183

    Also, the following section contains an example of the proper syntax:

    http://docs.oracle.com/cd/E11882_01/text.112/e24436/cexec.htm#CCREF2187

    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
  • 2. Re: load Thesaurus
    Barbara Boehmer Oracle ACE
    Currently Being Moderated
    Accidental duplicate post deleted.

    Edited by: Barbara Boehmer on Mar 5, 2013 11:42 AM
  • 3. Re: load Thesaurus
    994732 Newbie
    Currently Being Moderated
    Hi Barbara!

    Thank you very much for your quick response! It was vere useful to me.

    Best regards
    Sara

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points