UPK: ORA-00942 Error While Executing AlterSchemaObjects.sql During UPK Developer Server 12.1.0.2 Install

(Doc ID 2338852.1)

Last updated on JANUARY 12, 2018

Applies to:

User Productivity Kit - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Issue statement:
--------------------
When trying to upgrade Schema Objects executing AlterSchemaObjects.sql at the final step of Installation of UPK Developer Server 12.1.0.2 on Oracle 12.1.0.2 DB, an error message is displayed on the screen.

The ODSERVER, ODSERVER_APP schemas have been previously exported from an existing Oracle 11.1.0.2 Database for the purpose of importing them to the new Oracle 12.1.0.2 DB.

Environment:
---------------

UPK 12.1.0.2
Oracle 12.1.0.2 DB
Operation System: Microsoft Windows x64 (64-bit) 2008 R2

Error:
--------
There was an error running the SQL script AlterSchemaObjects.sql

Setup will now terminate.

Line: 43
Error: [Oracle][ODBC][Ora]ORA-00942 : table or view does not exist
ORA-06512: at line 13


Cause

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