My Oracle Support Banner

"ORA-00942" Message With Oracle Large Object (LOB) Datatype Fields In ODI Integration Interfaces (Doc ID 424658.1)

Last updated on DECEMBER 18, 2019

Applies to:

Oracle Data Integrator - Version 3.2.03.01 and later
Information in this document applies to any platform.

Symptoms

The following message is displayed by Oracle Data Integrator (ODI) in the loading phase when transferring data between 2 Oracle tables containing CLOB datatype fields:

ORA-00942: table or view does not exist

Note that the source table is stored in an Oracle 9i database and the target table in an Oracle 8i database.

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.