Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Data Modeler - Inability to create implied foreign key

nigel kingJan 24 2024 — edited Jan 24 2024

In attempting to create an implied Foreign Key I receive an error message “Can not create Implied Foreign Key to Fact Table!”

I have not consciously created a Fact Table. It is not clear why the system thinks it is a fact table. The table that I am attempting to draw the Foreign Key to has an Implied Foreign Key from it.

If I attempt to create the implied foreign key through by editing the table, the reference object is not visible in the list of objects that can be referenced.

Capture.PNG

Capture2.PNG

Capture3.PNG

Comments
Post Details
Added on Jan 24 2024
1 comment
66 views