My Oracle Support Banner

How To Specify The Physical Database Schema In ODI On Which An Index Will Be Created? (Doc ID 423994.1)

Last updated on JUNE 16, 2022

Applies to:

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

Goal

The following command has been inserted into an ODI Procedure step to create an Index:


The Logical Schema points to the PS1 Physical Schema but the Index was created in another database schema (corresponding to the RDBMS User declared for the connection to the Physical Architecture > Technology > Data Server > <my Data Server>).

When exporting the PS1 Schema into a new location, the previously created Index was lost.

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!


In this Document
Goal
Solution
References

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