My Oracle Support Banner

How Do the Values of the Internal IDs of ODI 10g and 11g Master and Work Repositories Impact Object Identifiers and Export-Import Procedures (Doc ID 786341.1)

Last updated on MAY 10, 2021

Applies to:

Oracle Data Integrator - Version to [Release 3.2.03 to 11gR1]
Information in this document applies to any platform.


Oracle Data Integrator (ODI) Master and Work Repositories are identified by their unique internal ID, a numeric value between 0 and 999.

The internal IDs are also used to compute the Primary Key of records stored in ODI Repository tables.

  1. How does the Master/Work Repository internal ID impact developments?
  2. How to decide which values may be be used?


This document is intended to those users that wish to:

  1. Understand how Primary Keys are computed by Oracle Data Integrator (ODI).
  2. Correctly handle Development, Integration... Production environments when the deployment is performed with ODI export - import operations.


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

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