My Oracle Support Banner

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

Last updated on JUNE 11, 2021

Applies to:

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


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
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


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

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