My Oracle Support Banner

Siebel Upgrade Failing with ORA-00942: table or view does not exist (Doc ID 1921516.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.11 [23030] and later
Information in this document applies to any platform.

Goal

Siebel upgrade - Synch Physical And Logical Indexes Step (Upgphys) the following error is shown in the syncidx2.log file:

2014-08-21 12:18:40 Running SQL statements against the database...
2014-08-21 12:18:40    Merging   table                   CX_AD_HOUSE_MEM ...  
2014-08-21 12:18:40    Merging   table                   CX_AD_SRPRV_INF ...  
2014-08-21 12:18:40    Merging   table                   CX_ADD_MED_INFO ...  
2014-08-21 12:18:40    Merging   table                   CX_ADD_OTHR_INF ...  
2014-08-21 12:18:40 SQL Statement:
create unique index EIM_AC_RSRC_U1 on EIM_AC_RSRC
("IF_ROW_BATCH_NUM", "ROW_ID")
tablespace SIEBEL_X
2014-08-21 12:18:40 [tp][ODBC Oracle driver][Oracle]ORA-00942: table or view does not exist

 

Note: Siebel upgrade from 7.8 to 8.1 version

Solution

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
Goal
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.