Re: ORA-02266

Need more information dude.

What were you doing when this occured?

I assume you were deleting and have database triggers on parent tables to delete from child ones. Or you have the Delete Cascade option on and its not quite working. Also, what DB version?

M

g5dejo_at_yahoo.com (Milko Kobila) wrote in message news:<3354ecc7.0110301203.68f650a4_at_posting.google.com>...
> Hello there,
>
> Can somebody please explain the origin of ORA-02266 ("unique/primary
> keys in table referenced by enabled foreign keys"). Why is this error
> generated even
> if both tables (referencing and refereced) are empty. I am not looking
> for solution to this problem, just the explanation.
>
> Thanks.
Received on Wed Oct 31 2001 - 14:33:40 CET