OTN Discussion Forums : "DRG-10700: preference does not exist: ...

Reply to this Thread

Search Forum

Back to Thread List

Replies: 3 - Pages: 1 - Last Post: Nov 10, 2008 7:19 PM Last Post By: Mike McLaughlin

Threads: [ Previous | Next ]

Martin_ARSAC

Posts: 2
Registered: 04/06/08

"DRG-10700: preference does not exist: french_lexer"
Posted: Apr 7, 2008 8:01 AM

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

Roger Ford

Posts: 838
Registered: 01/10/01

Re: "DRG-10700: preference does not exist: french_lexer"
Posted: Apr 7, 2008 9:31 AM

in response to: Martin_ARSAC

Where did you get the instructions to run drdeffrc.sql? I'm not aware of that script - I assume it's meant to be installed at installation time.

There is no french_lexer as such. If your language settings are set to French, then the system will use French defaults in the basic_lexer.

- Roger

Martin_ARSAC

Posts: 2
Registered: 04/06/08

Re: "DRG-10700: preference does not exist: french_lexer"
Posted: Apr 7, 2008 11:48 AM

in response to: Roger Ford

We are using an OS in english (SLES10), we are using a database with an english installation.

If you want to use Oracle Text with french words, you have to run this script drdeffrc.sql in order to add french words added to the default_stoplist.

Mike McLaughlin

Posts: 268
Registered: 11/08/05

Re: "DRG-10700: preference does not exist: french_lexer"
Posted: Jul 5, 2008 4:29 PM

in response to: Martin_ARSAC

The DRG-10700 also gets thrown when CTXAPP hasn't been granted to the user, provided you've chosen one of the available Oracle Text lexer types. More on my blog:

http://blog.mclaughlinsoftware.com/2008/07/05/lexers-and-privileges-errors/

Pages: 1

Back to Thread List

Threads: [ Previous | Next ]

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)