创建分区表

CREATE TABLE "DB19C"."LAB_APPLY"
   ( "ID" VARCHAR2(100),
 "OUTPATIENT_NUM" VARCHAR2(100),
 "NAME" VARCHAR2(180),
 "ID_NUM" VARCHAR2(180),
 "CLINIC_EMERGENCY_MARK_CODE" VARCHAR2(180),
 "FALG_FIRST_VISIT" VARCHAR2(180),
 "FALG_FIRST_VISIT_NAME" VARCHAR2(180),
 "ADMIN_ILLNESS_CODE" VARCHAR2(200),
 "ADMIN_ILLNESS_NAME" VARCHAR2(4000),
 "TREATMENT_SECTION_CODE" VARCHAR2(180),
 "TREATMENT_SECTION_NAME" VARCHAR2(180)
   ) TABLESPACE "USERS"
partition by range(ID)
( partition p1 values less than (5000),
  partition p2 values less than (maxvalue)
);

  

上一篇:十一、表分区


下一篇:mysql分区与分表