Skip to:
>[Error] Script lines: 377-381 ---------------------- ORA-02267: column type incompatible with referenced column type
>[Error] Script lines: 384-388 ---------------------- ORA-02267: column type incompatible with referenced column type
Here's the sql:
alter table SSQ_ANSWER add constraint FK390C0DCC6B21AFB4 foreign key (QUESTION_ID) references SSQ_QUESTION;
alter table SSQ_QUESTION add constraint FKFE88BA7443AD4C69 foreign key (SITETYPE_ID) references SSQ_SITETYPE_QUESTIONS;
Merged into 2.6.x @ 58340.
Fixed in r57912.
Zhen
Upping this to a blocker and assigning to John Leasia so UMich can address
>[Error] Script lines: 377-381 ---------------------- ORA-02267: column type incompatible with referenced column type
>[Error] Script lines: 384-388 ---------------------- ORA-02267: column type incompatible with referenced column type
Here's the sql:
alter table SSQ_ANSWER
add constraint FK390C0DCC6B21AFB4
foreign key (QUESTION_ID)
references SSQ_QUESTION;
alter table SSQ_QUESTION
add constraint FKFE88BA7443AD4C69
foreign key (SITETYPE_ID)
references SSQ_SITETYPE_QUESTIONS;