Skip to Main Content
Forums

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!

[SOLVED] Oracle SQL Data Modeler missing a PRIMARY KEY on DDL script export

Gael AbadinAug 21 2015 — edited Sep 7 2015

I am using Data Modeler 4.1.888 to create an ER diagram and generate a DDL script from it.

The diagram has over 40 tables, most of them have a primary key defined.

For some reason there is this one table, which has a primary key defined, but that's being ignored when I export the model to a DDL script.

This is the "offending" key (even though it's checked it is nowhere to be found on the generated DDL script):

4faS5.png

This is where the key is defined:

O5mPb.png

And this is the DDL preview (yes, the primary key shows up there):

SrwMu.png

This is what happens if I try to generate the DDL for just that table (primary key still not generated):

MljUm.png

Has anybody had the same problem? Any ideas on how to solve it?
This post has been answered by Gael Abadin on Sep 4 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2015
Added on Aug 21 2015
4 comments
1,191 views