Voltar
-
Título
Schema compare - Constraint shown both target source schema names -
Descrição
User did a schema compare ALTSDDB and ALTSTDB, Toad found differences on constraint and generated DDL with mixed schema names.
For example:
ALTER TABLE "ALTStDB"."TCHEND"
ADD CONSTRAINT "CHIMPK2_FK" FOREIGN KEY
("CHARGE_NMBR", "DCMNT_DISTRICT_CD", "TITLE_NMBR", "LTB_DISTRICT_CD")
REFERENCES "ALTSdDB"."TCHIMP"
("CHARGE_NMBR", "DCMNT_DISTRICT_CD", "TITLE_NMBR", "LTB_DISTRICT_CD")
ON DELETE CASCADE
ON UPDATE NO ACTION
ENFORCED
ENABLE QUERY OPTIMIZATION;However, in Sync1 and Sync2, DDL is generated fine.
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.