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!

Generate DDL Data Modeler with DEFERRABLE constraint

Ahmed RomihApr 3 2025

Hi all!

I have been using Oracle Data Modeler with 11g when generating DDL and everything was fine. When I switched to Generate DDL with 12cR2 option because I needed to get more characters than 30 for table names, the generated DDL removed all “DEFERRABLE” constraints.

With 11g I would have the following generated

CREATE TABLE XX
(

  id NUMBER (10) NOT NULL DEFERRABLE

);
ALTER TABLE XX ADD CHECK ( ID BETWEEN 0 AND 4294967295 ) DEFERRABLE;
ALTER TABLE XX ADD CONSTRAINT ... FOREIGN KEY (..) REFERENCES ... (..) DEFERRABLE;

Now with 12cR2 the DEFERRABLE would be stripped away

CREATE TABLE XX
(

  id NUMBER (10) NOT NULL

);
ALTER TABLE XX ADD CHECK ( ID BETWEEN 0 AND 4294967295 );
ALTER TABLE XX ADD CONSTRAINT ... FOREIGN KEY (..) REFERENCES ... (..);

How can I keep the DEFERRABLE constraint unchanged?

Thanks!

This post has been answered by J- on Apr 4 2025
Jump to Answer
Comments
Post Details
Added on Apr 3 2025
1 comment
160 views