ITPub博客

ORA-02298: cannot validate (A.TE_ID ) - parent keys not foundsolution:select xxxxx from child_table a where not exists (select 'x' fromparent_table where primary_key = a.key_values);This will show you the row (or rows) that exists in the child table thatdon't exist in the parent table. Once you have either (added rowsto the parent table to match the child rows) or (removed the childrows that don't have parents), then you can enable your RI constraintsSQL> select count(te_id)2 from A a3 where