¹ØÓÚOracleÖÐenable novalidateµÄÎÊÌâ

Çë¿´Ô´Âë £º
SQL code:

--´´½¨Ò»¸ö±í,ûÓÐÔ¼ÊøµÄ±í
CREATE TABLE test
( ID NUMBER(2),
NAME VARCHAR2(5));
--Ìí¼Ó¼Ç¼
INSERT INTO test VALUES('1','A');
INSERT INTO test VALUES('1','B');
INSERT INTO test VALUES('2','C');
--¸øtest±íÔö¼ÓÒ»¸öÖ÷¼üÔ¼Êø
ALTER TABLE test ADD CONSTRAINT test_id_pk PRIMARY KEY (ID) ENABLE NOVALIDATE;
--¼ÌÐøÌí¼Ó¼Ç¼
INSERT INTO test VALUES('1','A');
INSERT INTO test VALUES('1','B');
--Ìí¼Ó³É¹¦£¬Ã»±¨´í


ΪʲôÎÒдÁËÖ÷¼üÔ¼Êø²¢¼ÓÁËenable novalidate £¬µ«ºóÀ´Ìí¼ÓÊý¾Ýʱ£¬Í¬ÑùµÄID»¹ÊÇÄܳɹ¦£¬Ã»±¨´í£¿£¿¸ßÊÖÇëÂé·³Ïêϸ½âÊÍÏ¡£Èç¹û°´ÕÕÎÒµÄÒâ˼ ºöÂÔÒÔÇ°µÄÊý¾Ý£¬Ö»Ô¼ÊøºóÀ´Ìí¼ÓµÄÊý¾Ý£¬¸ÃÔõôдÄØ£¿£¿

---

ʲô°æ±¾

ÎÒÔõô¼ÓÔ¼Êø¾Í³ö´íÁË
SQL code:
SQL> select * from t2;

ID NAME
---------- -----
1 A
1 B
2 C

SQL> ALTER TABLE t2 ADD CONSTRAINT test_id_pk PRIMARY KEY (ID) ENABLE NOVALIDATE
;
ALTER TABLE t2 ADD CONSTRAINT test_id_pk PRIMARY KEY (ID) ENABLE NOVALIDATE
*
ERROR at line 1:
ORA-02437: cannot validate (SCOTT.TEST_ID_PK) - primary key violated

---

ÒýÓÃ

ʲô°æ±¾

ÎÒÔõô¼ÓÔ¼Êø¾Í³ö´íÁË
SQL codeSQL>select*from t2;