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
);
sql 表空间tablespace
最新推荐文章于 2022-12-23 13:21:17 发布