--prompt Dropping T_GIS_MAPINFO...
drop table T_GIS_MAPINFO cascade constraints;
prompt Creating T_GIS_MAPINFO...
-- Create table
create table T_GIS_MAPINFO
(
MAPID NUMBER(10) not null,
MAPNAME VARCHAR2(64) not null,
TNSLISTENER VARCHAR2(64),
HOSTIP VARCHAR2(16),
DATABASENAME VARCHAR2(64),
ORACLEPORT NUMBER(10) default 1521,
USERNAME VARCHAR2(128),
PASSWORD VARCHAR2(32),
WORKSPACENAME VARCHAR2(64),
WORKSPACEPATH VARCHAR2(512),
MAPVERSION VARCHAR2(32),
MODEL CHAR(1) default 0,
RESERVED1 NVARCHAR2(256)
)
tablespace TBS_GIS_DAT
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table T_GIS_MAPINFO
add constraint PK_MAPINFO primary key (MAPID)
using index
tablespace TBS_GIS_DAT
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);其中有如下的部分不是很理解,希望大家帮忙给讲讲啊1.tablespace TBS_GIS_DAT
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
这个有什么用啊?
drop table T_GIS_MAPINFO cascade constraints;
prompt Creating T_GIS_MAPINFO...
-- Create table
create table T_GIS_MAPINFO
(
MAPID NUMBER(10) not null,
MAPNAME VARCHAR2(64) not null,
TNSLISTENER VARCHAR2(64),
HOSTIP VARCHAR2(16),
DATABASENAME VARCHAR2(64),
ORACLEPORT NUMBER(10) default 1521,
USERNAME VARCHAR2(128),
PASSWORD VARCHAR2(32),
WORKSPACENAME VARCHAR2(64),
WORKSPACEPATH VARCHAR2(512),
MAPVERSION VARCHAR2(32),
MODEL CHAR(1) default 0,
RESERVED1 NVARCHAR2(256)
)
tablespace TBS_GIS_DAT
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table T_GIS_MAPINFO
add constraint PK_MAPINFO primary key (MAPID)
using index
tablespace TBS_GIS_DAT
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);其中有如下的部分不是很理解,希望大家帮忙给讲讲啊1.tablespace TBS_GIS_DAT
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
这个有什么用啊?
pctfree 10 --块剩余10%的空间时候,不可再插入
initrans 1 --初始事务数量
maxtrans 255 --最大事务数量
storage --存储参数
(
initial 64K --初始化64K
next 1M --每次扩展的时候增加的文件大小
minextents 1 --最小扩展段
maxextents unlimited --无最大扩展段限制
);
http://blog.csdn.net/iefus/archive/2011/02/22/6199375.aspx
这有点参考资料