My Oracle Support Banner

How To Set Up Simultaneous Launching of Multiple Parallel ODI Integration Interfaces (Mappings) that Feed the Same Target Datastore (Doc ID 423999.1)

Last updated on JANUARY 27, 2020

Applies to:

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


Data integration processing requirements oblige the simultaneous launching of multiple ODI Mappings (Integration Interfaces) that feed the same target Datastore.

The concern here is that ODI creates identically named C$, and I$ temporary integration tables for both Mappings (Integration Interfaces) with the result that collision occurs.

This results in the occasional display of the following message: 'table missing'.

Is there a way of avoiding these messages and are there any best practices in running multiple concurrent and simultaneous Interfaces for the same target Datastore?


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
 Why do the names of ODI temporary objects collide?
 How to avoid the collisions?
 Out-of-box solutions specific to ODI 12c
 Use ODI Variables for setting the prefix of C$ and I$ temporary tables
 Use Java Variables for setting the prefix of C$ and I$ temporary tables

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