3 Replies Latest reply: Nov 10, 2008 9:19 PM by 466751 RSS

    "DRG-10700: preference does not exist: french_lexer"

    632405
      Hi

      I am working on a database migration from 9.2.0.7 to 10.2.0.4.
      Everything is working fine but Oracle text no.

      The user CTXSYS is ok, he is granted all privilege

      I am trying to create this index, and I have got this error:

      CREATE INDEX USER.MY_TABLE_CTX01 ON USER.MY_TABLE
      (TITLE) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('storage mystore LEXER french_lexer');
      Error at line 3
      ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
      ORA-20000: Oracle Text error:
      DRG-10700: preference does not exist: french_lexer
      ORA-06512: at "CTXSYS.DRUE", line 160
      ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364

      But berfore creating this index, I create the french lexer with
      sqlplus ctxsys/<password> @defaults/drdeffrc.sql.

      The table "my_table" is very simple, title is varchar(2000).

      But i can create this index with the default options
      CREATE INDEX USER.MY_TABLE_CTX01 ON USER.MY_TABLE
      (TITLE) INDEXTYPE IS CTXSYS.CONTEXT ;

      I can't understant why french lexer seems to be not installed despite of running this script drdeffrc.sql.

      Any idea?

      Regards
      Martin