3 Replies Latest reply: Mar 7, 2013 12:35 PM by 994732 RSS

    load Thesaurus

    994732
      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
          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
            Accidental duplicate post deleted.

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

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

              Best regards
              Sara