constraint -enable novalidate 测试

理论上的东西不多说了，直接看测试结果：

[@more@]

SQL> desc jobs;

名称 是否为空? 类型

----------------------------------------- -------- ----------------------------

JOB_ID VARCHAR2(10)

JOB_TITLE NOT NULL VARCHAR2(35)

MIN_SALARY NUMBER(6)

MAX_SALARY NUMBER(6)

SQL> select *from jobs;

JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY

---------- ----------------------------------- ---------- ----------

AD_PRES President 20000 40000

AD_VP Administration Vice President 15000 30000

AD_ASST Administration Assistant 3000 6000

FI_MGR Finance Manager 8200 16000

FI_ACCOUNT Accountant 4200 9000

AC_MGR Accounting Manager 8200 16000

AC_ACCOUNT Public Accountant 4200 9000

SA_MAN Sales Manager 10000 20000

SA_REP Sales Representative 6000 12000

PU_MAN Purchasing Manager 8000 15000

PU_CLERK Purchasing Clerk 2500 5500

JOB_ID JOB_TITLE MIN_SALARY MAX_SALARY

---------- ----------------------------------- ---------- ----------

ST_MAN Stock Manager 5500 8500

ST_CLERK Stock Clerk 2000 5000

SH_CLERK Shipping Clerk 2500 5500

IT_PROG Programmer 4000 10000

MK_MAN Marketing Manager 9000 15000

MK_REP Marketing Representative 4000 9000

HR_REP Human Resources Representative 4000 9000

PR_REP Public Relations Representative 4500 10500

AD_PRES my job title 0 0

已选择20行。

SQL> create index indx_jobid on jobs(job_id);

索引已创建。 *

SQL> alter table jobs add constraint pk_jobid primary key(job_id) using index indx_jobid;

表已更改。

SQL> insert into jobs values('AD_PRES','my job title',0,0);

insert into jobs values('AD_PRES','my job title',0,0)

*

ERROR 位于第 1 行:

ORA-00001: 违反唯一约束条件 (RUANWQ.PK_JOBID)

SQL> alter table jobs disable novalidate primary key;

表已更改。

SQL> insert into jobs values('AD_PRES','my job title',0,0);

已创建 1 行。

SQL> commit;

提交完成。

SQL> alter table jobs enable novalidate primary key;

表已更改。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/814/viewspace-852152/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/814/viewspace-852152/