My Oracle Support Banner

"ORA-00942: table or view does not exist & ORA-02063: preceding line from <NAME>" Errors Received when Executing ODI 12c Mapping with DBLINK LKM (Doc ID 2500993.1)

Last updated on MAY 03, 2023

Applies to:

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


A mapping which has been configured in Oracle Data Integrator (ODI)  or makes use of a Loading Knowledge Module (LKM) with DBLINK functionality.

When the mapping is executed via ODI Studio, the following error is received:

This issue can be reproduced at will with the following steps:

  1. Open ODI Studio
  2. Locate and open or create a mapping which pulls one table from each of two different source databases, joins the source tables, and inserts the data into a third (target) database
  3. Attempt to run the mapping and observe the error stack reported above.


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.