Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CONSTRAINTS ENABLE on 7.3.4
I'm pretty sure that disabling / enabling constraints was introduced in
Oracle 8.0. Are you sure you have the database version right?=20
-----Original Message-----
Seema Singh
One of my database is 7.34 on hp-ux.Somehow one of our developer disable
one=20
of constraints.When I have tried to enable i noticed ora-02298 because
of=20
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=20
??
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 19 2004 - 19:13:54 CDT
![]() |
![]() |