How To Create a Concurrent Program to Synchronize (Refresh) the iStore InterMedia Search Index of the Search Table
Last updated on JANUARY 24, 2017
Applies to:Oracle iStore - Version 188.8.131.52 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
When using the iStore Search feature, first and only once, it is necessary to run the "iStore Search Insert" which will populate the Search table, but if any item is created, updated, or deleted, the Search table will be updated with the help of some triggers, but not the InterMedia index which is used to search for those items. The iStore documentation states that it is necessary to run the following command to synchronize this index:
The problem with this is that is not user friendly, but it is possible to change this by creating a concurrent program to run that command.
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