Oracle 10g创建索引、主健约束及删除SQL语句

Category: 技术相关|Tech Author: pingcenter View: 313 viewsDate: 2010-07-30

一、删除主健约束：

ALTER TABLE POSQULT.TB_M30_ITEMS DROP CONSTRAINT M30_ITEMS_PK CASCADE

二、创建主健约束：

ALTER TABLE POSQULT.TB_M30_MOLTEN_ITEMS ADD (
CONSTRAINT M30_MOLTEN_ITEMS_PK
PRIMARY KEY
(MOLTEN_STEEL_CHAR_CD)
    USING INDEX
    TABLESPACE TS_M30_QULT_IDXS
    PCTFREE    10
    INITRANS   2
    MAXTRANS   255
    STORAGE    (
                INITIAL          256K
                NEXT             256K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                PCTINCREASE      0
               ));

三、创建索引：

CREATE INDEX IX_C44CLAI030_N2 ON TB_C44_CLAI030
(CLAIM_NO,CLAIM_PRODUCT_NO,CLAIM_CUSTOMER)
LOGGING
TABLESPACE TS_C44_QDES_IDXS
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          256K
            NEXT             64K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
NOPARALLEL;