My Oracle Support Banner

UPK: ORA-00942 Error While Executing AlterSchemaObjects.sql During UPK Developer Server on Oracle DB (Doc ID 2338852.1)

Last updated on FEBRUARY 07, 2019

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


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.