Constraints validated

Hi,

I 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 ?
I thought all my data was NOT NULL
if the constraint is validate.

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

Something I didn't understand ???

Oracle 9.2.05 AIX 5.1

Thanks in advance



.

Relevant Pages

  • Re: Child records with no parent in 10.2.0.3
    ... >>> SQL> ALTER TABLE temp_child DISABLE VALIDATE CONSTRAINT ... Because the constraint constrains the child table and only the child ... DISABLE VALIDATE will effectively lock the child table from any ...
    (comp.databases.oracle.server)
  • Re: Problem with OLEDB - cant see all tables in DBC
    ... Looks like the problem was partly because there was a constraint on the ... table referencing something I hadn't pulled in. ... Have you done a VALIDATE DATA RECOVER on the DBC? ...
    (microsoft.public.fox.vfp.dbc)
  • Re: Sequential Number in an Update
    ... I would really like to know how you would validate this as a ... URL in a constraint. ... CREATE TABLE UserLinks ... CREATE PROCEDURE SwapUserLinks ...
    (comp.databases.ms-sqlserver)
  • Re: how to check where integrity constraints are being violated
    ... This is to migrate data from a legacy system to our new ... Obviously it would have to be specific to sybase since it would ... Validate every FK constraint on a table? ...
    (comp.databases.sybase)
  • Re: Impact on changing an enabled validated constraint to enable novalidate ?
    ... We would like to change constraints that are enabled and validated to ... I feel that once validated there is no point in keeping the constraint ... VALIDATE seems only useful when we create a constraint on existing ... Typically enable novalidate is only useful when you need to accept ...
    (comp.databases.oracle.server)