My Oracle Support Banner

ORA-00942 Errors Are Encountered When Running ImportSDOThemes.bat for MWM v2.0.1.7 (Doc ID 1612283.1)

Last updated on JANUARY 10, 2014

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.0.1.7 and later
Information in this document applies to any platform.

Symptoms

 When attempting to run importSDOThemes.bat included with Patch 17252559 (MWM v2.0.1.7), the following error is encountered:

INSERT INTO USER_SDO_THEMES SELECT * FROM ZZ_USER_SDO_THEMES ZST WHERE NOT EXISTS (SELECT 1 FROM USER_SDO_THEMES UST WHERE ZST.NAME=UST.NAME)
                                          *
ERROR at line 1:
ORA-00942: table or view does not exist

 
DROP TABLE ZZ_USER_SDO_THEMES
           *
ERROR at line 1:
ORA-00942: table or view does not exist

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.