'ORA-00942: table or view does not exist' Signalled When Attempting To Import an ODI 11g Load Plan Into an Execution Type Repository
(Doc ID 1567833.1)
Last updated on JUNE 16, 2022
Applies to:
Oracle Data Integrator - Version 11.1.1.5.0 to 11.1.1.6.4 [Release 11gR1]Information in this document applies to any platform.
Symptoms
When attempting to import an ODI 11g Development environment exported Load Plan into an Execution type Repository in Synonym Mode Insert_Update mode, the operation fails with the following message:
com.sunopsis.dwg.SQLWorkReposException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
....
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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |