Oracle Commerce Service Center (CSC): When Creating SRCH_SEARCH_* Indexes Encountering DRG-10700: Preference Does Not Exist: Specifying ATGSEARCHLEXER

(Doc ID 1911347.1)

Last updated on AUGUST 26, 2015

Applies to:

Oracle Commerce Service Center - Version 11.0 and later
Information in this document applies to any platform.


Beginning in Oracle Commerce Service Center (CSC) version 11 and later, profile and order search uses a full text search as described in
Note 1909996.1 - Oracle Commerce Version 11.1 What's New Reference

This article describes a problem in which the full text search indexes SRCH_SEARCH_ORDER_IDX and SRCH_SEARCH_PROFILE_IDX were dropped.
Then they were recreated with the script:


The creation failed with these errors:


Upgraded to Oracle Commerce 11. Due to issues with SRCH_ORDER_TOKENS and SRCH_PROFILE_TOKENS it was decided to drop and recreate the SRCH_SEARCH_ORDER_IDX and SRCH_SEARCH_PROFILE_IDX.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms