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 JUNE 16, 2022

Applies to:

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


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:

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


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.