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!

Recursive FK

LindsaySApr 16 2021

We are having a problem with data modeller when handling a recursive relation.
As an example:
logical.pngHere the FK attribute has been renamed via SQL Developer to supervisorid. When this is engineered to a relational model. this first time the renamed FK is shown as the original name:
rel1.pngIf you engineer a second time, the FK now has the correct name:
rel2.pngThis has not been our experience up to to 20.2, it is the case in 20.4 and 21.1

Comments

My idea would be: debug it.

Your post had so little technical information so I can't be more specific, sorry.

[I know this isn't a Perl forum, but since isn't one on OTN, I'm OK with you asking it here]

1 - 1

Post Details

Added on Apr 16 2021
1 comment
317 views