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 OCTOBER 14, 2019

Applies to:

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



Purpose

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?

Scope

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.

Details

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
Purpose
Scope
Details
References

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