oracle constraints(2)

oracle Ô¼ÊøµÄ״̬
  oracleÔÚ´´½¨Ô¼ÊøºóĬÈÏ״̬ÊÇenabled VALIDATED
SQL> create table T2
2 (
3 VID NUMBER,
4 VNAME VARCHAR2(10) not null,
5 VSEX VARCHAR2(10) not null
6 )
7 /

Table created

SQL> alter table t2 add constraints PK_T primary key (vid);

Table altered

SQL> select t.constraint_name, t.status, t.validated from user_constraints t;

CONSTRAINT_NAME STATUS VALIDATED
------------------------------ -------- -------------
SYS_C003762 ENABLED VALIDATED
SYS_C003763 ENABLED VALIDATED
PK_T ENABLED VALIDATED
oracleÔ¼ÊøÒ»¹²ÓÐ4ÖÖ״̬:enabled validated, enabled novalidated, disadble validated, disable novalidated¡£
enabled validated ÊÇĬÈÏ״̬£¬±íʾÊý¾ÝÔÚÔ¼Êø´´½¨Ê±Òª¶ÔÊý¾Ý¿âÄÚµÄÊý¾Ý½øÐÐУÑé²¢ÇÒͬʱԼÊøºóÀ´²åÈëµÄÊý¾ÝÂú×ãÔ¼ÊøÌõ¼þ¡£
enabled novalidated ±íʾ²»¶ÔÊý¾Ý¿âÄÚµÄÊý¾Ý½øÐÐУÑé¶øÖ»ÊÇÒªÇóºóÀ´²åÈëµÄÊý¾ÝÂú×ãÔ¼ÊøÌõ¼þ¡£
SQL> select * from t2;

VID VNAME VSEX
---------- ---------- ----------
1 a y
2 b
3 c x

SQL> alter table t2 modify VSEX not null enable novalidate;

Table altered

SQL> select * from t2;

VID VNAME VSEX
---------- ---------- ----------
1 a y
2 b
3 c x
SQL> insert into t2 values ('4','d','');

insert into t2 values ('4','d','')

ORA-01400: ÎÞ·¨½« NULL ²åÈë ("PORTALDB"."T2"."VSEX")

SQL>
SQL> select t.constraint_name, t.status, t.validated from user_constraints t;

CONSTRAINT_NAME STATUS VALIDATED
------------------------------ -------- -------------
SYS_C003765 ENABLED VALIDATED
PK_T ENABLED VALIDATED
SYS_C003768 ENABLED NOT VALIDATED
¶ÔÓÚΨһԼÊøºÍÖ÷¼üÔ¼ÊøÓÉÓÚÔÚ´´½¨Ê±ºòÒª´´½¨Î¨Ò»Ë÷Òý£¬ËùÒÔÔÚÆÕͨ±íÖÐÈç¹û±íÖÐÊý¾ÝÓÐÎ¥·´Ô¼Êøµ