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

(Doc ID 2338852.1)

Last updated on JANUARY 12, 2018

Applies to:

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


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

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


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

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


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