My Oracle Support Banner

OdiImportObject Is Throwing "Table or view does not exist" Error While Importing Datastore in ODI 11g (Doc ID 2261577.1)

Last updated on APRIL 29, 2021

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

While trying to import model into Oracle Data Integrator (ODI) 11g, datastore and project using ODIImportObject. It is importing the model but throwing following error while importing datastore:

Caused by: com.sunopsis.dwg.SQLMasterReposException: ORA-00942: table or view does not exist

The command being run is:

sh $ODI_HOME/bin/startcmd.sh OdiImportObject -FILE_NAME="<DATASTORE_EXPORT_FILENAME>.xml" -WORK_REP_NAME=<WORK_REPOSITORY> -IMPORT_MODE=SYNONYM_INSERT_UPDATE

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.