Skip to Content
0

Views based on objects located in external models

Jul 19, 2017 at 01:48 PM

27

avatar image
Former Member

I'm just wondering, what's the process for creating Oracle Views based on Tables located

in other models?

What I have done so far:

1) I have an model, containing two packages (each package represents a DB schema). In each of the packages, I have a table (the table names/codes are same in both packages). What is different is the owner

2) I have a second model, where we are creating the Views.

Now... I wasn't able to create the Views, until I haven't created a shortcut for the base tables (found in the other model mentioned in 1) ...

Now I'm able to create the View... but:

a) somehow PD is not able to display the columns for the second table. It references always the first one, although I'm selecting the second table in the Table tab

b) when creating the View in the model, only one shortcut (to the first Table) is created. The shortcut to the second table is missing - the consequence is a wrong/inconsistent lineage.

I think, the problem is the name of the source table. Both tables have the same name and code, the only difference is the owner. But this is correct.

Is it a bug? If not, what's wrong with my models? How to workaround it?

BR,

Rafal

views.jpg (164.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers