Scheduled OPTIMIZE_INDEX Job fails with an DRG-10502: index {index_name} does not exist

(Doc ID 2341089.1)

Last updated on DECEMBER 19, 2017

Applies to:

Oracle Text - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

 In 12.2.0.1, a scheduled OPTIMIZE_INDEX job fails with an DRG-10502: index <index_name> does not exist when the index exists and is VALID:

Cause

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