Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: CONSTRAINTS ENABLE on 7.3.4

RE: CONSTRAINTS ENABLE on 7.3.4

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 19 Oct 2004 17:18:24 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87AC0@irvmbxw02>


I'm pretty sure that disabling / enabling constraints was introduced in Oracle 8.0. Are you sure you have the database version right?=20

-----Original Message-----
Seema Singh

One of my database is 7.34 on hp-ux.Somehow one of our developer disable one=20
of constraints.When I have tried to enable i noticed ora-02298 because of=20
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=20
??

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 19 2004 - 19:13:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US