CONSTRAINTS ENABLE on 7.3.4

  • From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 19 Oct 2004 12:20:11 -0400

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® 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

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

Other related posts: