oracle rac 分区要求,RAC环境下的分区表分构方案对比

CREATE TABLE T_SCAN

(        ID CHAR(22) NOT NULL ENABLE,

MANINO VARCHAR2(25),

REFNO VARCHAR2(20),

JOBNO VARCHAR2(20),

CARNO VARCHAR2(20),

CAGENO VARCHAR2(20),

BAGNO VARCHAR2(20),

CHILDJOBNO VARCHAR2(20),

FREQUENCYNO VARCHAR2(4),

SENDSTATION_ID VARCHAR2(20),

CURRSTATION_ID VARCHAR2(20),

CTRNO VARCHAR2(20),

CTRNAME VARCHAR2(40),

DESTSTATION_ID VARCHAR2(10),

SCANTYPE_ID VARCHAR2(20),

SCANTYPENAME VARCHAR2(120),

PCS NUMBER(18,0),

INPUTWEIGHT NUMBER(18,4),

LENGTH NUMBER(18,4),

WIDTH NUMBER(18,4),

HEIGHT NUMBER(18,4),

VOLWEIGHT NUMBER(18,4),

ACTUALWEIGHT NUMBER(18,4),

FEEWEIGHT NUMBER(18,4),

DELIVERYTIMELIMIT_ID VARCHAR2(20),

BILLTYPE_ID VARCHAR2(20),

DELIVERYSERVICETYPE_ID VARCHAR2(20),

BUSINESSTYPE_ID VARCHAR2(20),

CURRSCANOBJECTTYPE_ID NUMBER(*,0),

REMARK VARCHAR2(40),

SCANUSER_ID VARCHAR2(20),

SCANDATETIME DATE,

ISUPLOAD CHAR(1),

UPLOADDATETIME DATE,

SCANDEVICECODE VARCHAR2(20),

ISCOUNTFEE CHAR(1),

UPLOADUSER_ID VARCHAR2(10),

ISREPEAT CHAR(1),

BILLSTATUS_ID VARCHAR2(20),

COMPUTERNAME VARCHAR2(20),

UPDATEUSER_ID VARCHAR2(10),

UPDATEUSERNAME VARCHAR2(20),

UPDATESTATION_ID VARCHAR2(10),

UPDATEDATETIME DATE,

SCANDEVICETYPE_ID VARCHAR2(10),

SCANUSERNAME VARCHAR2(20),

UPLOADUSERNAME VARCHAR2(20),

UPLOADSTATION_ID VARCHAR2(10),

FEE NUMBER(18,4),

ISARREST CHAR(1),

LIST_ID CHAR(22),

LICENSENO VARCHAR2(10),

TRAFFIC_ID VARCHAR2(10),

BAK1 VARCHAR2(20),

BAK2 VARCHAR2(20),

BAK3 VARCHAR2(20),

TAREWEIGHT NUMBER(18,4),

CONSTRAINT SHIP_SCANPOD_PK PRIMARY KEY (ID)

USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS

STORAGE(INITIAL 536870912 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

TABLESPACE TS_IND_T_SCAN ENABLE

) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255  LOGGING

STORAGE(

BUFFER_POOL DEFAULT)

TABLESPACE EXPRESS_SHIP_TABLE

PARTITION BY RANGE (SCANDATETIME)

(PARTITION PS_SCAN_200805_01  VALUES LESS THAN (TO_DATE(' 2008-05-10 23:59:59', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255

STORAGE(INITIAL 109051904 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

TABLESPACE PS_SCAN_200805_01 NOCOMPRESS ,

..................