ALTER TABLE “HM”.“MGL_ALLGEMEINE_DATEN” MODIFY (“SEX” CONSTRAINT “MGL_ALLG_DAT_MOW” CHECK (AsText))
And what’s that ?
GRANT SELECT ON “HM_TEST”.“PLZ_IN” TO “HM”, gives ORA-01749
/GRANT EXECUTE ON AIRAIS_MGL_SPRACHEN TO HM_WEB;
GRANT EXECUTE ON AIRAIS_MGL_SPRACHEN TO HM_ADMIN;
is has been generated. The original script shows it. It’s no change made by me.
it’s boring !
Now I have a generated script and wants to make the changes, but I’m heavily struggeled in entities and indexes are not there but supposed to be, others are there, but believed they are not … .
After 80 errors I stopped running the script. And more are in …
I put the ORA-xxxx Messages in the script. Please see it. There is one 01741, many 02273, many 02449, many 02429, some 00942, three 01418, one 02260, one 00920,
In my model I devided my entities up into three Workspaces. Every Workspace has Tables in one user. The sript should do this.
Did I use it wrong ?
I have already corrected the identifying relationships like you told me. I have also the new scripts in place for generating Trigger for sequences and for FK case 773601
See attached files
And : what’s this ?
And take a look at this :
I clicked “generating with purge”. No Table was dropped with purge !#
All TS_ Triggers are invalid
FK Indices and Constraints are not generated ( see 773601 )
Please show me a solution for all 7 bullet points.
AlterScript_PCA_aus_generiertem_HAMAA_extra_Reengeneered_mit_FK_Patch.sql (651 KB)
HalloMarie8.0.txp (2.46 MB)
HalloMarieRE_HAMAA.txp (5.45 MB)