RE: CONSTRAINTS ENABLE on 7.3.4
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <oracledbam@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Oct 2004 12:29:34 -0400
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@xxxxxxxxxxx]=20
Sent: Tuesday, October 19, 2004 12:20 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
