My Oracle Support Banner

Is It Possible to Share "AS Common Schemas" Across Multiple ODI 12c Repositories ? (Doc ID 1622204.1)

Last updated on MARCH 18, 2023

Applies to:

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

Goal

When creating ODI 12c Repository using RCU some AS Common Schemas are created in addition to the ODI Repository Schema.

For a Standalone Installation, RCU creates STB schema:

 

For an Enterprise Installation, RCU creates OPSS and IAU schemas:

NOTE: The prefix 'DEV' shown in the above screenshot is a sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

Are all those ODI 12c schemas created for each ODI 12c Repository setup?

Can they be re-used by distinct ODI 12c Repositories?

Solution

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.