如何实现分段存储

Question

卡片信息/执卡人信息/应用报警信息分段表
/*==============================================================*/
/* Table: TB_IM_CARD_SECTION                                    */
/*==============================================================*/
create table TB_IM_CARD_SECTION  (
   CARD_SECTION         VARCHAR(6)                      not null,段号
   DB_CODE              VARCHAR(20)                     not null,数据库标识
   CARD_AMOUNT          NUMBER(7)                       not null,已有卡片数
   HOLDER_CARD_AMOUNT   NUMBER(7)                       not null,已有执卡人数
   STATE                CHAR(3)                         not null 状态
);
持卡人信息(XXXXXX段)
/*==============================================================*/
/* Table: TB_IM_CARD_HOLDER_XXXXXX                              */
/*==============================================================*/
create table TB_IM_CARD_HOLDER_XXXXXX  (
   HOLDER_SEQ           VARCHAR(20)                     not null,持卡人流水
   HOLDER_NAME          VARCHAR(64)                     not null,姓名
   SSN                  VARCHAR(10),                             SSN
   ID_CARD              VARCHAR(18),                             身份证号
   PHY_NUMBER           VARCHAR(30)                     not null,卡片物理号
   LOG_NUMBER           VARCHAR(30)                     not null,卡片逻辑号
   OLD_PHY_NUMBER       VARCHAR(30),                             原卡物理号
   OLD_LOG_NUMBER       VARCHAR(30),                             原卡逻辑号
   ENTRANCE_DATE        CHAR(6)                         not null,入学年月
   发放日期             DATE                            not null,发放日期
   DEAL_SEQ             VARCHAR(22)                     not null,数据提交流水
   STATE                CHAR(3)                         not null,状态
   constraint PK_IM_CARD_HOLDER primary key (HOLDER_SEQ)
);
校园卡卡片信息(XXXXXX段)
/*==============================================================*/
/* Table: TB_IM_CARD_XXXXXX                                     */
/*==============================================================*/
create table TB_IM_CARD_XXXXXX  (
   CARD_SEQ             VARCHAR(20)                     not null,
   PHY_NUMBER           VARCHAR(30),
   LOG_NUMBER           VARCHAR(30)                     not null,
   CARD_TYPE            VARCHAR(5),
   PRO_NUMBER           VARCHAR(10)                     not null,
   INIT_DATE            DATE,
   HOLDER_SEQ           VARCHAR(20)                     not null,
   DEAL_SEQ             VARCHAR(22)                     not null,
   STATE                CHAR(3)                         not null,
   constraint PK_IM_CARD primary key (CARD_SEQ)
);comment on column TB_IM_CARD_XXXXXX.CARD_SEQ is
'格式: YYYYMMDD+XXXXXX，后六位为序列';校园卡应用报警信息(XXXXXX段)
/*==============================================================*/
/* Table: TB_IM_ALARM_INFO_XXXXXX                               */
/*==============================================================*/
create table TB_IM_ALARM_INFO_XXXXXX  (
   ALARM_INFO_SEQ       VARCHAR(20)                     not null,
   ALARM_TYPE           VARCHAR(5)                      not null,
   HOLDER_NAME          VARCHAR(60)                     not null,
   SSN                  VARCHAR(10),
   ID_CARD              VARCHAR(18),
   PHY_NUMBER           VARCHAR(30)                     not null,
   LOG_NUMBER           VARCHAR(30)                     not null,
   ALARM_DATE           DATE                            not null,
   DEAL_SEQ             VARCHAR(22)                     not null,
   STATE                CHAR(3)                         not null,
   constraint PK_IM_ALARM_INFO primary key (ALARM_INFO_SEQ)
);comment on column TB_IM_ALARM_INFO_XXXXXX.ALARM_TYPE is
'黑名单、卡数据篡改、卡伪造、卡复制等';
请问如何实现分段存储，

Answer 1

oracle 分段存储管理

Answer 2

create tablespace的时候指定extent management local就可以用ASSM来高效的管理你的segment了。