create table BUSINESS--创建表名
(
businessid NUMBER(19) not null,--字段名,类型,长度,是否可为空
)
tablespace DBINFECTIOUS --指定表空间
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table BUSINESS
add constraint PKBUSINESSID primary key (BUSINESSID)--创建主键索引等
using index
tablespace USERS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);