DPS Table Upgrades Executed On Catalog Switch A/B Schemas Incorrectly During Migration Resulting in Error: ORA-00942: table or view does not exist

(Doc ID 2146654.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle Commerce Platform - Version 10.0 and later
Information in this document applies to any platform.


When upgrading Oracle Commerce to version 10.2, the ATG Upgrade and Migration Guide [10.1.2 to 10.2] instructs you to execute the run_dcs_switching_all.{bat|sh} script to migrate the switching schemas. This script executes the following sub-scripts:

The script fails when executing the run_dps_core.{bat|sh} script because it references DPS related tables that don't exist in the switching schemas. These may fail with the following error: ORA-00942: table or view does not exist 


The database schemas being upgraded were created manually and without the use of CIM. 


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