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
Million Knowledge Articles and hundreds of Community platforms