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 laterOracle 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! |