分区表的全局索引创建的一种方式

 CREATE TABLE DT_AS_SERVICE_ITEMS_P

   (  COMPANY_ID NUMBER(4,0) NOT NULL ,

  SI_CODE VARCHAR2(16) NOT NULL ,

  MHN_CODE VARCHAR2(8) NOT NULL ,

  SI_NAME VARCHAR2(128 CHAR) NOT NULL ,

  TREE_ID NUMBER(8),

  SPELLING_CODE VARCHAR2(32),

  PRM_MAN_HOURS NUMBER(8,2),

  AUX_MAN_HOURS NUMBER(8,2),

  STD_MAN_HOURS NUMBER(8,2),

  ACT_MAN_HOURS NUMBER(8,2),

  DISPATCHING_MH NUMBER(8,2),

  ADJ_MAN_HOURS NUMBER(6,2),

  ADJ_ACTIVE_DATE TIMESTAMP (6),

  FIXED_PRICE_USED NUMBER(1),

  FIXED_PRICE NUMBER(10,2),

  ADD_SI_CODES VARCHAR2(128),

  FP_ID NUMBER(12),

  FP_CODE VARCHAR2(16),

  SI_CATEGORY NUMBER(8),

  DISCOUNTING NUMBER(1) DEFAULT 1,

  IS_NOTARIZED NUMBER(1),

  IS_NOTARIZED_TW NUMBER(1) DEFAULT 0,

  IS_FREQUENTLY NUMBER(1),

  USED_TIMES NUMBER(12),

  OEM_FLAG NUMBER(1) DEFAULT 0,

  IS_INACTIVE NUMBER(1) DEFAULT 0,

  ACTIVE_DATE TIMESTAMP (6),

  REMARK VARCHAR2(128 CHAR),

  CREATED_BY NUMBER(8,0),

  CREATED_TIME TIMESTAMP (6),

  UPDATED_BY NUMBER(8),

  UPDATED_TIME TIMESTAMP (6),

  VERSION NUMBER(8) DEFAULT 0,

   CONSTRAINT PK_DT_AS_SERVICE_ITEMS_P PRIMARY KEY (COMPANY_ID, SI_CODE, MHN_CODE)

)

   GLOBAL  PARTITION BY RANGE (COMPANY_ID)

 (PARTITION PT1  VALUES LESS THAN (1100)

  TABLESPACE DMS ,

 PARTITION PT2  VALUES LESS THAN (1250)

  TABLESPACE DMS ,

 PARTITION PT3  VALUES LESS THAN (1380) TABLESPACE DMS,

  PARTITION PT4  VALUES LESS THAN (maxvalue)

 )

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27110163/viewspace-741527/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27110163/viewspace-741527/