I have come accross the following problem while reverse engineering our company’s physical data model. We are using Oracle 10g R2 and our TDM version is 18.104.22.168
In example, I have the following case in DB:
create table t1 (a number(3));
create table t2 (a number(5), b number(2));
alter table t1 add constraint pk_t1 primary key (t1);
I have reverse engineered the tables and the primary key into TDM and I would like to create a foreign key constraint from t2 to t1. When I add the relationship on TDM’s physical model, the data type of the referencing column in the child table (t2.a) automatically becomes the same as the referenced column in the parent table’s (t1.a). By the way, I have already tried changing the foreign key column of the child table with F2 key… I believe this case is not related with the F2 thingy.
It is possible to create a foreign key constraint on Oracle without changing the data types: alter table t2 add constraint fk_t2 foreign key (a) references t1(a); is it not possible to create such a relationship on TDM 3.5. while keeping the original data types?
I was expecting TDM to let me create the relationship but display a warning during model verification.
I hope I could explain the case, thanks,
Message was edited by: burcu.orbay_1238172634468