Re: ORA-02298, cannot enable constraint

Hi !

I try to answser to you :
I understand that when want to enable a constraint ORACLE can not enbale this constraint because parent record are not found ?

If it is the case, you have to use the "exception into " clause when you enable your constraint .
See Doc ALTER TABLE clause, find EXCEPTION You will find an example :
ALTER TABLE census
 ADD CONSTRAINT unq_city_state
 UNIQUE (city, state)
 USING INDEX PCTFREE 5
  TABLESPACE user_y
 EXCEPTIONS INTO bad_keys_in_ship_cont

Bye !

Joe <joe_at_vulcan.achq.dnd.ca> a écrit dans le message : NNmn4.3468$a27.116102_at_news1.rdc1.mb.home.com...
> I have gotten the subject message and am stuck.
> The Cause is because of orphaned records in the table
> The Action to take is to make sure there are no orphaned records in the
> table before issuing the command.
>
> My questions are, which table are the orphaned records in (the one
 pointing
> from or to), and how do you find orphaned records,?
>
> Any help will be greatly appreciated.
>
> Joe McSheffery
> Winnipeg
>
>
>
>
Received on Wed Feb 09 2000 - 00:00:00 CET