By fixing the data I would be able to enable constraints That I know.WOndering is any way we can fix without fixing data. >From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx> >Reply-To: Jacques.Kilchoer@xxxxxxxxx >To: <oracle-l@xxxxxxxxxxxxx> >Subject: RE: CONSTRAINTS ENABLE on 7.3.4 >Date: Tue, 19 Oct 2004 17:39:06 -0700 > >I sure would like to take that back now. I was thinking of validate / >novalidate. DISABLE / ENABLE was available in Oracle 7 and probably >earlier. >As another poster said, in Oracle 7.3.4, you will need to fix the data. >Or if you want to have a constraint but can't fix the data, you could >write a trigger that emulates the constraint. > >-----Original Message----- >Jacques Kilchoer > >I'm pretty sure that disabling / enabling constraints was introduced in >Oracle 8.0. Are you sure you have the database version right? > >-----Original Message----- >Seema Singh > >One of my database is 7.34 on hp-ux.Somehow one of our developer disable >one >of constraints.When I have tried to enable i noticed ora-02298 because >of >data inconsistent. >When I run >ALTER TABLE <NAMEOFTABLE> ENABLE NONVALIDATE CONSTRAINT <NAMEOF >CONSTRAINT>; >Didn't work.WOndering is there anyway we can enable constraints >forecelly or > > > >-- >//www.freelists.org/webpage/oracle-l _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ -- //www.freelists.org/webpage/oracle-l