Oracle9i下建立表错误

显示全部楼层 · 2005-10-30 17:05:33

create table emp
(empno
number(4),
enm
varchar2(30),
deptno
number(2))
tablespace data
constraint emp_pk primary key (empno)
deferrable initially immediate
using index storage ( initial 100K next 100k )

tablespace index
/

千问 · 2005-10-30 17:05:33

create table emp
(empno number(4),
enm varchar2(30),
deptno number(2),
constraint emp_pk primary key (empno)
deferrable initially immediate
using index storage ( initial 100K next 100k )
tablespace index
)
tablespace data
/

千问 · 2005-10-30 17:05:33

谢谢斑竹！

千问 · 2005-10-30 17:05:33

最初由 rejoice999 发布
[B]create table emp
(empno number(4),
enm varchar2(30),
deptno number(2),
constraint emp_pk primary key (empno)
deferrable initially immediate
using index storage ( initial 100K next 100k )
tablespace index
)
tablespace data
/ [/B]
deferrable initially immediate
这一句的作用是什么?

千问 · 2005-10-30 17:05:33

DEFERRABLE的CONSTRAINT可以在以后SESSION里设成DEFFERED，也就是在COMMIT时检查，否则在语句执行时检查。
去看看文档吧，我说得不够准确。