My Oracle Support Banner

How To Query and Validate the External Tables in ADW Loads in ODI on Marketplace (Doc ID 2788758.1)

Last updated on MARCH 16, 2023

Applies to:

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


External tables are used in multiple Loading Knowledge Modules (LKM) while loading to Autonomous Data Warehouse (ADW) in Oracle Data Integrator (ODI) on Marketplace.

E.g. LKM Object Storage to ADWC External Table and LKM BICC to ADW External Table

Sometimes when the loads fail on the external tables with the following error, there is no further information or actual reason for failure.

This article explains on how to query and validate the errors related to the loading of external tables in ADW target 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!

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