RE: CONSTRAINTS ENABLE on 7.3.4
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
