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: Seema Singh <oracledbam_at_hotmail.com>
Date: Wed, 20 Oct 2004 14:52:31 -0400
Message-ID: <BAY19-F1O8FNpyLAPDV0000964d@hotmail.com>


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_at_quest.com>
>Reply-To: Jacques.Kilchoer_at_quest.com
>To: <oracle-l_at_freelists.org>
>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
>
>
>
>--
>http://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/
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 20 2004 - 13:48:42 CDT

Original text of this message

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