"DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER" error occurs when creating the private repository in Toad. The Oracle objects, UTLMAIL and UTLSMTP packages, and CTX user are installed. Installations of these Oracle objects finished without error.
But when creating the private repository within Toad, it errors out at the point that Toad asks for email settings. Enter in email info and then it prompts that objecst are missing and suggests reinstallation.
The error(s) continue even after trying to reinstall the objects.
CREATE INDEX TOADCLOUD_DATA.PUB_FILES_CONTENTS_IDX ON
TOADCLOUD_DATA.PUBLIC_FILES
(FILE_CONTENTS_TEXT)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('SYNC (ON COMMIT)')
Error at line 1901
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
Try suggested fix of reapplying the correct drdefXX.sql script for the database locale.
http://unix.soteks.org/2011/database/oracle-ctxsys-lexer-issues/Note, the article is related to the noted error, but is not specific to Toad and private repository. You can review the noted article as a suggestions and try testing in your own environment. Please note these suggestions are general Oracle suggestions based off of 3rd party information, not administered or monitored by Quest Software. The root of the issue is on Oracle and related to the objects installed. You man need to go to Oracle support or additional DBA resource on your end to troubleshoot if this error continues to be an issue.
