I’m not sure if this is an error already covered in my other posts, but to be sure I’ll send you this case.
I have been doing my sync & convert, generate alter script and reverse engeneered directly from my database. ( At the end of the task I stored the rev eng model before closing modeler ).
For the tables AKTIVITAETSLOG and AKTLOG_HIST he is not generating the Foreign Key Index. Statement
CREATE INDEX “AKTIVITAETSL_MGLID_FK_IDX” ON “HM”.“AKTIVITAETSLOG” (“MGLID_ID”)
could be seen at SQL Preview, but is not generated. Same for AKTLOG_HIST.
But he is genarating statement
ALTER TABLE “HM”.“AKTIVITAETSLOG” ADD CONSTRAINT “AKTIVITAETSL_MGLID_FK” FOREIGN KEY (“MGLID_ID”) REFERENCES “HM”.“MITGLIEDER” (“MGLID”)
( also seen in preview ), but this statement leads to error ORA-02298
Seee attached modells.
I use the additional sended scripts for generating FK and Triggers. See error case 773601.
HalloMarie8.1.txp (2.53 MB)
HalloMarieRE_HAMAA_Fehler_mit_fehlendem_index_aktlog.txp (2.53 MB)