My Oracle Support Banner

Ora-1418, Specified Index Does Not Exist - Rgoptm Module: Program - Optimizer (Doc ID 264068.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle General Ledger - Version 11.5 and later
Information in this document applies to any platform.

Symptoms

The General Ledger Optimizer progam (RGOPTM) errors out with something similar to this in the log file:

SEGMENT1 already indexed
SEGMENT2 already indexed
Dropping unwanted indexes.....
Index Status
------------------------ --------
>> gluddl() 14-FEB-2004 20:07:55
<< gluddl() 14-FEB-2004 20:07:56
GL_CODE_COMBINATIONS_N1 Error
rgomid() encountered an error returning from index_not_dropped:
ERROR: ORA-01418: specified index does not exist
ORA-06512: at "SYSTEM.AD_DDL

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.