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: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 19 Oct 2004 12:29:34 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA6501B9DEE6@25exch1.vicorpower.vicr.com>


Better yet, find the offending row of data & fix the problem. Look in the SQL Reference manual under enable constraint exceptions into <table_name>.=20

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----

From: Seema Singh [mailto:oracledbam_at_hotmail.com]=20 Sent: Tuesday, October 19, 2004 12:20 PM To: oracle-l_at_freelists.org
Subject: CONSTRAINTS ENABLE on 7.3.4

Hi,
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 ??
thanks
-Seema



Is your PC infected? Get a FREE online computer virus scan from McAfee(r) Security.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3D3963

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Oct 19 2004 - 11:25:09 CDT

Original text of this message

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