3 Replies Latest reply on Mar 7, 2013 6:35 PM by 994732

    load Thesaurus


      i'm having problems loading a thesaurus:

      ctx_thes.create_thesaurus('thesa', FALSE);

      the thesaurus is created. Then I try to load it:

      ctxload -thes -name thesa -file 'C:\Users\Sara\Desktop\test.txt'

      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
        • 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:


          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
          • 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
              Hi Barbara!

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

              Best regards