Re: ORA-02298, cannot enable constraint

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Wed, 09 Feb 2000 15:58:38 GMT
Message-ID: <O8go4.24$bG4.1019@nreader1.kpnqwest.net>

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 - 09:58:38 CST