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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

IDENTITY Column Not Generating (Data Modeler Ver 17.2, Oracle DB 12C.R2)

randy789Jul 23 2017 — edited Jul 28 2017

Hello,

I don't think the new SQL Developer generates IDENTITY columns anymore. Esp when selecting Oracle 12C.R2.

Noticed this when converting over an older model and PK columns were suddenly not working....

Steps to recreate the bug are below. Brand new model with only one table.

pastedImage_0.png

pastedImage_1.png

pastedImage_2.png

pastedImage_4.png

DDL GENERATED:

CREATE TABLE table_1 (

pk   NUMBER NOT NULL

);

ALTER TABLE table_1 ADD CONSTRAINT table_1_pk PRIMARY KEY ( pk );

CREATE SEQUENCE table_1_pk_seq START WITH 1 NOCACHE ORDER;

This post has been answered by Philip Stoyanov-Oracle on Jul 24 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2017
Added on Jul 23 2017
5 comments
1,905 views