My Oracle Support Banner

How To Create a Concurrent Program to Synchronize (Refresh) the iStore InterMedia Search Index of the Search Table (Doc ID 828892.1)

Last updated on MAY 10, 2022

Applies to:

Oracle iStore - Version and later
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.


To view full details, sign in with your My Oracle Support account.

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

In this Document
 Known Issue

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.