Re: Integrity constraint violated

> Not very likely.
> Oracle doesn't generate constraints automatically.
> If it did generate constraints, it is because you or someone else, is
> using Designer, and instructed it do to so.
> It looks like either you or someone else has made a design error, and
> you need to rectify this. Drop the foreign key (alter table drop
> constraint) and set up the correct one.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Well, I'm sure that it was generated automatically.The only one tool I'm using is TOAD.Maybe this tool can do such things either. The correct script value for this constraint should be ALTER TABLE ZAMOWIENIA_POZYCJE ADD (
  CONSTRAINT ZAM_POZ_STAWKA_VAT_FK FOREIGN KEY (STAWKA_VAT_ID)     REFERENCES STAWKI_VAT (ID));
So the name of the referenced table is incorrect. Thanks for help.

Best regards,
Marcin Received on Tue Aug 08 2006 - 07:01:28 CDT