createpartobj.sql

oracle 全文检索的示例代码. 实现基于分区表的全文检索实现

prompt
prompt Creating table T_EMAIL_CONTENT
prompt ==============================
prompt
create table T_EMAIL_CONTENT
(
  EMAIL_SEQ  NUMBER not null,
  EXTNAME    VARCHAR2(8),
  BODYTYPE   VARCHAR2(8),
  MAILBODY   BLOB,
  EMLCONTENT BLOB
)
lob(MAILBODY,EMLCONTENT) STORE AS  (TABLESPACE misslob CACHE disable storage in row )
partition by range (EMAIL_SEQ)
(
  partition P_20000101 values less than (2000000000000000000)
    tablespace miss
    pctfree 0
  pctused 80
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      minextents 1
      maxextents unlimited
    )
)cache  nologging
;

alter table T_EMAIL_CONTENT
  add constraint T_EMAIL_CONTENT_PK primary key (EMAIL_SEQ) using index tablespace idx_miss;

prompt
prompt Creating table T_HTTP_CONTENT
prompt =============================
prompt
create table T_HTTP_CONTENT
(
  HTTP_SEQ NUMBER not null,
  EXTNAME  VARCHAR2(8),
  DATA     BLOB
)
lob(data) STORE AS  (TABLESPACE misslob CACHE disable storage in row )
partition by range (http_seq)
(
  partition P_20000101 values less than (2000000000000000000)
    tablespace miss
    pctfree 0
  pctused 80
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      minextents 1
      maxextents unlimited
    )
)cache  nologging
;

alter table T_HTTP_CONTENT
  add constraint T_HTTP_CONTENT_PK primary key (HTTP_SEQ) using index tablespace idx_miss;


prompt
prompt Creating table T_TELNET_CONTENT
prompt ===============================
prompt
create table T_TELNET_CONTENT
(
  TELNET_SEQ NUMBER not null,
  EXTNAME    VARCHAR2(8),
  DATA       BLOB
)
lob(data) STORE AS  (TABLESPACE misslob CACHE disable storage in row )
partition by range (TELNET_SEQ)
(
  partition P_20000101 values less than (2000000000000000000)
    tablespace miss
    pctfree 0
  pctused 80
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      minextents 1
      maxextents unlimited
    )
)cache  nologging
;

alter table T_TELNET_CONTENT
  add constraint T_TELNET_CONTENT_PK primary key (TELNET_SEQ) using index tablespace idx_miss;

prompt
prompt Creating table T_WAP_CONTENT
prompt ============================
prompt
create table T_WAP_CONTENT
(
  WAP_SEQ NUMBER not null,
  EXTNAME VARCHAR2(8),
  DATA    BLOB
)
lob(data) STORE AS  (TABLESPACE misslob CACHE disable storage in row )
partition by range (WAP_SEQ)
(
  partition P_20000101 values less than (2000000000000000000)
    tablespace miss
    pctfree 0
  pctused 80
    initrans 1
    maxtrans 255
    storage
    (
      initial 64K
      minextents 1
      maxextents unlimited
    )
)cache  nologging
;
alter table T_WAP_CONTENT
  add constraint T_WAP_CONTENT_PK primary key (WAP_SEQ) using index tablespace idx_miss;

exit;