Toad World® Forums

Bug in rebuild script

Toad 13.3.0.181 x64, Oracle client 19.3 x64
Rebuild table, generate error:

ALTER TABLE XXX.OPDIST_ARCH ADD
CONSTRAINT OPDIST_ARCH_1FK
FOREIGN KEY (JOB_NAME, JOB_REC, DB_PREFIX)
REFERENCES XXX.OPPAR_DB (OPPAR_DB_JOB_NAME, OPPAR_DB_JOB_REC, OPPAR_DB_PREFIX)
ON DELETE CASCADEDISABLE;

Also NOVALIDATE after DISABLE is missing (in mine case).
So please recheck the whole logic in this area.

Thanks Damir, I can reproduce that.