It seems that the way toad for oracle generated a create table script from an existing table has changed. It seems that previous version created seperate statements for each constraint. now it seems it generates a single statement. Is there a switch that changed this behaviour ?
before:
ALTER TABLE my_schema.tabl1 ADD (
CONSTRAINT FK1
FOREIGN KEY (ID1)
REFERENCES my_schema.tabl2 (ID1)
ENABLE VALIDATE);
ALTER TABLE my_schema.tabl1 ADD (
CONSTRAINT FK2
FOREIGN KEY (ID1)
REFERENCES my_schema.tabl3 (ID2)
ON DELETE SET NULL );
now
ALTER TABLE my_schema.tabl1 ADD (
CONSTRAINT FK1
FOREIGN KEY (ID1)
REFERENCES my_schema.tabl2 (ID1)
ENABLE VALIDATE,
CONSTRAINT FK2
FOREIGN KEY (ID1)
REFERENCES my_schema.tabl3 (ID2)
ON DELETE SET NULL
);