1 Reply Latest reply on Jan 16, 2009 5:23 PM by Barbara Boehmer

    Thesaurus loading + DRG-11510: encountered unrecoverable error on line 1

    678347
      Hi All
      I want to load thesarus present in the oracle home directory, so from command prompt i gave 'ctxload' command and gave the required inputs as shown below.

      cmd prompt

      D:\Documents and Settings\Administrator>ctxload
      Enter user: ctxsys/ctxsys@mind2
      Enter name: default
      Enter file: E:\app\Administrator\product\11.1.0\db_1\ctx\sample\thes\dr0thsus.txt

      Connecting...
      DRG-11510: encountered unrecoverable error on line 1
      ORA-00931: missing identifier

      Disconnected

      Can anyone tell what is the error?
      Do we have to create a thesaurus 'default' before only and then load it using 'ctxload' command?
      Please can anybody explain how to create and load a thesarus?

      Thank You
        • 1. Re: Thesaurus loading + DRG-11510: encountered unrecoverable error on line 1
          Barbara Boehmer
          It appears it is expecting "ctxload -thes", not just "ctxload", even though "-thes" is not listed as part of the required syntax. It also requries that the default thesaurus does not already exist, so if you have one, then drop it. Below I have first reproduced your error, then added "-thes" with an already existing default thesaurus, showing what happens then, then dropped the default thesaurus, then demonstrated a correct load.

          -- from operating system command prompt:
          C:\app\Barbara\product\11.1.0\db_1\BIN>ctxload
          Enter user: ctxsys/ctxsys@orcl
          Enter name: default
          Enter file: C:\app\Barbara\product\11.1.0\db_1\ctx\sample\thes\dr0thsus.txt
          Connecting...
          DRG-11510: encountered unrecoverable error on line 1
          ORA-00931: missing identifier

          Disconnected

          C:\app\Barbara\product\11.1.0\db_1\BIN>ctxload -thes
          Enter user: ctxsys/ctxsys@orcl
          Enter name: default
          Enter file: C:\app\Barbara\product\11.1.0\db_1\ctx\sample\thes\dr0thsus.txt
          Connecting...
          Creating thesaurus default...
          ORA-20000: Oracle Text error:
          DRG-11700: thesaurus default already exists
          ORA-06512: at "CTXSYS.DRUE", line 160
          ORA-06512: at "CTXSYS.DRITHSL", line 13
          ORA-06512: at line 1

          Disconnected

          -- from SQL*Plus:
          CTXSYS@orcl_11g> exec ctx_thes.drop_thesaurus ('default')

          PL/SQL procedure successfully completed.

          CTXSYS@orcl_11g>

          -- back to operating system command prompt:
          C:\app\Barbara\product\11.1.0\db_1\BIN>ctxload -thes
          Enter user: ctxsys/ctxsys@orcl
          Enter name: default
          Enter file: C:\app\Barbara\product\11.1.0\db_1\ctx\sample\thes\dr0thsus.txt
          Connecting...
          Creating thesaurus default...
          Thesaurus default created...
          Processing...
          1000 lines processed
          2000 lines processed
          3000 lines processed
          4000 lines processed
          5000 lines processed
          6000 lines processed
          7000 lines processed
          8000 lines processed
          9000 lines processed
          10000 lines processed
          11000 lines processed
          12000 lines processed
          13000 lines processed
          14000 lines processed
          15000 lines processed
          16000 lines processed
          17000 lines processed
          18000 lines processed
          19000 lines processed
          20000 lines processed
          21000 lines processed
          21760 lines processed successfully
          Beginning insert...21760 lines inserted successfully
          Disconnected

          C:\app\Barbara\product\11.1.0\db_1\BIN>