I whish to now if there is a way to manage cross oracle schemas foreign keys between two tables, having them transformed into a logical model.
I have a customer who wants to transform two logical packages into two different oracle schemas due to relationships between two (or more) entities contained into logical packages. This is because they have two (or more) tables into oracle belongs to two different schemas.
The problem during the logical to physical transformation is that, having a single schema into the wizard to which tranform the logical model, will create all tables and relationship into a single schema.
Even if you create a separate schema to replicate the configuration that they have into Oracle, the next logical to physical transformation will "reunite" the tables into a single schema.
Is there a workaround or a practice to manage the "cross schema" Foreign Keys?
Pinned topic Cross Schema Foreign Keys Management
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-07-30T18:01:40Z at 2012-07-30T18:01:40Z by hskolwal
hskolwal 120000N9MM11 Posts
Re: Cross Schema Foreign Keys Management2012-07-30T18:01:40ZThis is the accepted answer. This is the accepted answer.Hi Marco,
There already exists an RFE filed to support transform from multiple packages to multiple schemas and vice-versa.
I am afraid there is no workaround for this issue today.