
REM  CREATE TABLE "SYSTEM"."ITEMS2" ("ORD_ID" NUMBER(3, 0), "PROD_CODE" 
REM  NUMBER(6, 0), "QTY" NUMBER(4, 0)) PCTFREE 10 PCTUSED 40 INITRANS 1 
REM  MAXTRANS 255 LOGGING STORAGE(INITIAL 40960 NEXT 24576 MINEXTENTS 1 
REM  MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 
REM  BUFFER_POOL DEFAULT) TABLESPACE "DATA01" ;
CONNECT SYSTEM;
CREATE INDEX "SYSTEM"."ITEM_OID_IDX" ON "ITEMS2" ("ORD_ID" ) PCTFREE 10 
INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 10240 NEXT 10240 MINEXTENTS 1 
MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL 
DEFAULT) TABLESPACE "INDX01" LOGGING ;
