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!