sql 表空间tablespace

create table T10_PAGE_IN_VAL
(
  PARMVALKEY VARCHAR2(10) not null,
  REPORTKEY  VARCHAR2(60) not null,
  PARMKEY    VARCHAR2(12),
  PARMNAME   VARCHAR2(64),
  PARMCD     VARCHAR2(64),
  ISNESS     CHAR(1),
  ISHIDECOL  CHAR(1),
  PARMSEQ    NUMBER(10),
  ISVALCOL   CHAR(1)
)
tablespace TSDAT01--表段T10_PAGE_IN_VAL放在表空间TSDAT01中
  pctfree 10                 --块保留10%的空间留给更新该块数据使用
  initrans 1--初始化事务槽的个数
  maxtrans 255--最大事务槽的个数
  storage--存储参数
  (
    initial 64K--区段(extent)一次扩展64k
    next 1M
    minextents 1--最小区段数
    maxextents unlimited--最大区段无限制 
  );
-- Add comments to the table 
comment on table T10_PAGE_IN_VAL  is '模版页面参数值列表';
-- Add comments to the columns 
comment on column T10_PAGE_IN_VAL.PARMVALKEY  is '备用';
comment on column T10_PAGE_IN_VAL.REPORTKEY  is '内部生成(rp_)';
comment on column T10_PAGE_IN_VAL.PARMCD  is '页面参数编码';
comment on column T10_PAGE_IN_VAL.ISNESS  is '参见：T10002，备用';
comment on column T10_PAGE_IN_VAL.ISHIDECOL  is '参见：T10002，备用';
comment on column T10_PAGE_IN_VAL.ISVALCOL  is '参见：T10002，根据值列匹配';
-- Create/Recreate primary, unique and foreign key constraints 
alter table T10_PAGE_IN_VAL
  add constraint PK_T10_PAGE_IN_VAL primary key (PARMVALKEY, REPORTKEY)
  using index 
  tablespace TSIND01
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );