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 DECEMBER 08, 2023

Applies to:

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

Goal

The following command has been inserted into an Oracle Data Integrator (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!


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