From oracle-l-bounce@freelists.org Wed Oct 20 13:48:42 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9KImgS08713 for ; Wed, 20 Oct 2004 13:48:42 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i9KImgI08708 for ; Wed, 20 Oct 2004 13:48:42 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B217872D935; Wed, 20 Oct 2004 13:54:51 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05518-70; Wed, 20 Oct 2004 13:54:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CF96E72DA9D; Wed, 20 Oct 2004 13:54:48 -0500 (EST) X-Originating-IP: [65.114.163.33] X-Originating-Email: [oracledbam@hotmail.com] X-Sender: oracledbam@hotmail.com From: "Seema Singh" To: Jacques.Kilchoer@quest.com, oracle-l@freelists.org Subject: RE: CONSTRAINTS ENABLE on 7.3.4 Date: Wed, 20 Oct 2004 14:52:31 -0400 Mime-Version: 1.0 Content-type: text/plain Message-ID: X-OriginalArrivalTime: 20 Oct 2004 18:53:03.0862 (UTC) FILETIME=[0784D960:01C4B6D6] Content-Transfer-Encoding: 8bit X-archive-position: 11317 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: oracledbam@hotmail.com Precedence: normal Reply-To: oracledbam@hotmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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" >Reply-To: Jacques.Kilchoer@quest.com >To: >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 ENABLE NONVALIDATE CONSTRAINT 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