DDL Source for INDEX a1.DBOTARGETUSER.I_IL1

This page was created on: 28 March 2017, 11:53

[ DB a1 Home ] [ Schema DBOTARGETUSER Home ] [ INDEXES Home ] [ DDL Wizard Home ]

CREATE INDEX "I_IL1" 
    ON "DBO_INVOICE_LINE" 
    (
        "WAREHOUSE_ID" ,
        "ITEM_ID" 
    ) 
    PCTFREE 10 
    INITRANS 2 
    MAXTRANS 255 
    STORAGE ( 
        INITIAL 65536 
        NEXT 1048576 
        MINEXTENTS 1 
        FREELISTS 1 
        FREELIST GROUPS 1 
        BUFFER_POOL DEFAULT ) TABLESPACE "USERS" LOGGING 
;


[ DDL Wizard Home ]

This page was generated by the public version of the Net 2000 Ltd. DDLWizard software. Net 2000 Ltd. publishes other useful software for Oracle databases: Data Masker which replaces sensitive information in test and development databases with realistic looking anonymous data and DataBee the simplest and easiest way to create referentially correct subsets of large Oracle databases.