Re: Constraints validated

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 30 Jan 2006 23:52:19 -0800
Message-ID: <1138693939.143597.276550@o13g2000cwo.googlegroups.com>

>>have a table with a constraint NOT NULL
>>wich is enable, validate,
>>but there is some rows with a null value.
>>How is it posssble ?

The constraint may be INVALID.

>>I did disable
>>and after I can't enable it
>>which is OK

>>Something I didn't understand ???

When you disabled it an then tried to enable it the constraint tried to become VALID but the data whithin the column made it impossible.

HTH Cheers.

Carlos. Received on Tue Jan 31 2006 - 01:52:19 CST