Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Logical delete rule: no action results in fk with cascade delete

user10413762Nov 1 2016 — edited Nov 1 2016

In logical model I have a relation with delete rule no action. In relational model the fk rule is cascade.

When engineering to relational model the difference is seen but not applied (compare/copy option is set).

1.png

DM does not see the difference in delete rule as a change?

2.png

How can I engineer the change in delete rule to relational model? Is there some other setting required to make DM see this as a change that needs to be engineered?

Using DM 4.1.3 (same behaviour seen in 4.1.5)

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 29 2016
Added on Nov 1 2016
2 comments
518 views