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 NOVEMBER 15, 2023

Applies to:

Oracle Data Integrator - Version 3.2.03.01 to 10.1.3.6.0
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:

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!

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