How to Query and Validate the External Tables in ADW Loads in ODI on Marketplace
(Doc ID 2788758.1)
Last updated on JULY 07, 2021
Applies to:Oracle Data Integrator on Marketplace - Version 220.127.116.11.210321 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!
In this Document