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!

Auto Increment Sequence/Trigger DDL issue

OraTechAficionadoMay 14 2015 — edited May 18 2015

Not exactly sure where to begin here.... Under the Column Properties within the Table Properties for my table, I turned on the Auto Increment checkbox for the table as noted here in General.

Auto Increment.jpg

For the Auto Increment section of the Column Properties I added both the Sequence and Trigger Name I wanted as noted below.

Auto Increment2.jpg

However, when I Right-Click on the table and select DDL Preview, this is what I see at the bottom of the DDL script.

Please note that the Sequence DDL is created correctly but now there are 2 entries for the Trigger DDL - one with the name I requested and the other is some system generated one.

Am I doing something wrong or is this a bug?

DDL Preview.jpg

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2015
Added on May 14 2015
5 comments
1,934 views