My Oracle Support Banner

Cr35240a.sql - SQL Error: ORA-01418: Specified Index Does Not Exist (Doc ID 2391354.1)

Last updated on JULY 30, 2018

Applies to:

Oracle Communications MetaSolv Solution - Version 6.3.0 and later
Information in this document applies to any platform.


On MSS 6.3.0

During the upgrade Prod fix sql scripts cr35240a.sql and 11829593.sql fails when the indexes and constraints used in the scripts respectively does not exist in the database.

Sample scripts log files:

 C:\mss_6.3\MSS.R6_3_0.b555_DBInstall\nsdev\prodfixsql_logs\11829593.log (1 hit)
 Line 185: -- -2431, ORA-02431: cannot disable constraint (SE_IN__SE_TE) - no such constraint
  C:\mss_6.3\MSS.R6_3_0.b555_DBInstall\nsdev\prodfixsql_logs\19497547.log (2 hits)
Line 99: --ORA-12002: there is no materialized view log on table
Line 102: --ORA-12003: materialized view does not exist



These scripts should not fail as the indexes and constraints for which they are failing do not exist in the database.


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.