CREATE TABLE "RMS"."ITEM_LOC_SOH"
( "ITEM" VARCHAR2(25 BYTE) NOT NULL ENABLE,
"ITEM_PARENT" VARCHAR2(25 BYTE),
"ITEM_GRANDPARENT" VARCHAR2(25 BYTE),
"LOC" NUMBER(10,0) NOT NULL ENABLE,
"LOC_TYPE" VARCHAR2(1 BYTE) NOT NULL ENABLE,
"AV_COST" NUMBER(20,4),
"UNIT_COST" NUMBER(20,4),
"STOCK_ON_HAND" NUMBER(12,4) NOT NULL ENABLE,
"SOH_UPDATE_DATETIME" DATE,
"LAST_HIST_EXPORT_DATE" DATE,
"IN_TRANSIT_QTY" NUMBER(12,4) NOT NULL ENABLE,
"PACK_COMP_INTRAN" NUMBER(12,4) NOT NULL ENABLE,
"PACK_COMP_SOH" NUMBER(12,4) NOT NULL ENABLE,
"TSF_RESERVED_QTY" NUMBER(12,4) NOT NULL ENABLE,
"PACK_COMP_RESV" NUMBER(12,4) NOT NULL ENABLE,
"TSF_EXPECTED_QTY" NUMBER(12,4) NOT NULL ENABLE,
"PACK_COMP_EXP" NUMBER(12,4) NOT NULL ENABLE,
"RTV_QTY" NUMBER(12,4) NOT NULL ENABLE,
"NON_SELLABLE_QTY" NUMBER(12,4) NOT NULL ENABLE,
"CUSTOMER_RESV" NUMBER(12,4) NOT NULL ENABLE,
"CUSTOMER_BACKORDER" NUMBER(12,4) NOT NULL ENABLE,
"PACK_COMP_CUST_RESV" NUMBER(12,4) NOT NULL ENABLE,
"PACK_COMP_CUST_BACK" NUMBER(12,4) NOT NULL ENABLE,
"CREATE_DATETIME" DATE NOT NULL ENABLE,
"LAST_UPDATE_DATETIME" DATE NOT NULL ENABLE,
"LAST_UPDATE_ID" VARCHAR2(30 BYTE) NOT NULL ENABLE,
"FIRST_RECEIVED" DATE,
"LAST_RECEIVED" DATE,
"QTY_RECEIVED" NUMBER(12,4),
"FIRST_SOLD" DATE,
"LAST_SOLD" DATE,
"QTY_SOLD" NUMBER(12,4),
"PRIMARY_SUPP" NUMBER(10,0),
"PRIMARY_CNTRY" VARCHAR2(3 BYTE),
"AVERAGE_WEIGHT" NUMBER(12,4),
"FINISHER_AV_RETAIL" NUMBER(20,4),
"FINISHER_UNITS" NUMBER(12,4),
"PACK_COMP_NON_SELLABLE" NUMBER(12,4) NOT NULL ENABLE,
CONSTRAINT "PK_ITEM_LOC_SOH" PRIMARY KEY ("ITEM", "LOC")
USING INDEX PCTFREE 10 INITRANS 12 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_INDEX" ENABLE,
CONSTRAINT "CHK_ITEM_LOC_INV_LOC_TYPE" CHECK (LOC_TYPE in ('S','W','E')) ENABLE,
SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS,
CONSTRAINT "ILI_IEM_FK3" FOREIGN KEY ("ITEM_GRANDPARENT")
REFERENCES "RMS"."ITEM_MASTER" ("ITEM") ENABLE,
CONSTRAINT "ILI_ITL_FK" FOREIGN KEY ("ITEM", "LOC")
REFERENCES "RMS"."ITEM_LOC" ("ITEM", "LOC") ENABLE,
CONSTRAINT "ILI_IEM_FK" FOREIGN KEY ("ITEM")
REFERENCES "RMS"."ITEM_MASTER" ("ITEM") ENABLE,
CONSTRAINT "ILI_IEM_FK2" FOREIGN KEY ("ITEM_PARENT")
REFERENCES "RMS"."ITEM_MASTER" ("ITEM") ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA"
PARTITION BY HASH ("LOC")
(PARTITION "ITEM_LOC_SOH_P001" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P002" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P003" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P004" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P005" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P006" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P007" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P008" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P009" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P010" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P011" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P012" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P013" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P014" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P015" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P016" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P017" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P018" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P019" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P020" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P021" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P022" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P023" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P024" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P025" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P026" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P027" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P028" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P029" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P030" SEGMENT CREATION DEFERRED
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P031" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P032" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P033" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P034" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P035" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P036" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P037" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P038" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P039" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P040" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P041" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P042" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P043" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P044" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P045" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P046" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P047" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P048" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P049" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P050" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P051" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P052" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P053" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P054" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P055" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P056" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P057" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P058" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P059" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P060" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P061" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P062" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P063" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P064" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P065" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P066" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P067" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P068" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P069" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P070" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P071" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P072" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P073" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P074" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P075" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P076" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P077" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P078" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P079" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P080" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P081" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P082" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P083" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P084" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P085" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P086" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P087" SEGMENT CREATION DEFERRED
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P088" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P089" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P090" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P091" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P092" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P093" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P094" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P095" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P096" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P097" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P098" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P099" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P100" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P101" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P102" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P103" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P104" SEGMENT CREATION DEFERRED
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P105" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P106" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P107" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P108" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P109" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P110" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P111" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P112" SEGMENT CREATION DEFERRED
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P113" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P114" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P115" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P116" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P117" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P118" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P119" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P120" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P121" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P122" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P123" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P124" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P125" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P126" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P127" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P128" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P129" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P130" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P131" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P132" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P133" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P134" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P135" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P136" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P137" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P138" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P139" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P140" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P141" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P142" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P143" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P144" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P145" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P146" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P147" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P148" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P149" SEGMENT CREATION DEFERRED
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P150" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P151" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P152" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P153" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P154" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P155" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P156" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P157" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P158" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P159" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P160" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P161" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P162" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P163" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P164" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P165" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P166" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P167" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P168" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P169" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P170" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P171" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P172" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P173" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P174" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P175" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P176" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P177" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P178" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P179" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P180" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P181" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P182" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P183" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P184" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P185" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P186" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P187" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P188" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P189" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P190" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P191" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P192" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P193" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P194" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P195" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P196" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P197" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P198" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P199" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P200" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P201" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P202" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P203" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P204" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P205" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P206" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P207" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P208" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P209" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P210" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P211" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P212" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P213" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P214" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P215" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P216" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P217" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P218" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P219" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P220" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P221" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P222" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P223" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P224" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P225" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P226" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P227" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P228" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P229" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P230" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P231" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P232" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P233" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P234" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P235" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P236" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P237" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P238" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P239" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P240" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P241" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P242" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P243" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P244" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P245" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P246" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P247" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P248" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P249" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P250" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P251" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P252" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P253" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P254" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P255" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ,
PARTITION "ITEM_LOC_SOH_P256" SEGMENT CREATION IMMEDIATE
TABLESPACE "RETEK_DATA"
NOCOMPRESS ) ;
COMMENT ON TABLE "RMS"."ITEM_LOC_SOH" IS 'PARTITION BY HASH (LOC), LOCAL PK, GLOBAL INDEXES';
CREATE INDEX "RMS"."ITEM_LOC_SOH_I3" ON "RMS"."ITEM_LOC_SOH" ("ITEM_PARENT")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_INDEX" ;
CREATE INDEX "RMS"."ITEM_LOC_SOH_I4" ON "RMS"."ITEM_LOC_SOH" ("ITEM_GRANDPARENT")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 106496 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_INDEX" ;
CREATE OR REPLACE TRIGGER "RMS"."XXLM_RMS_ITEM_LOC_SOH_AIU_2"
AFTER INSERT OR UPDATE ON ITEM_LOC_SOH
FOR EACH ROW
-- <1.001> <2018-04-25> <Yuri Volushkov> logging av_cost = NULL, initial version
-- <1.002> <2018-08-03> <Yuri Volushkov> change log info
declare
c_program constant varchar2(50) := 'XXLM_RMS_ITEM_LOC_SOH_AIU_2';
c_event_name varchar2(50) := 'XXLM_AV_COST_NULL';
l_dml_type varchar2(10);
l_user varchar2(50);
-- l_sysdate date := sysdate;
l_osuser varchar2(100);
l_host varchar2(100);
l_module varchar2(100);
l_action varchar2(100);
l_client_info varchar2(64);
l_sid varchar2(100);
l_message_text varchar2(4000);
begin
if (inserting and :new.av_cost is not NULL)
or (updating and :new.av_cost is NULL and :old.av_cost is NULL)
or (updating and :new.av_cost is not NULL and :old.av_cost is not NULL) then
return;
end if;
-- logging:
-- inserting - :new.av_cost is NULL
-- updating - :old.av_cost is not NULL -> :new.av_cost is NULL
-- updating - :old.av_cost is NULL -> :new.av_cost is not NULL
if inserting then
l_dml_type := 'INSERT';
else
l_dml_type := 'UPDATE';
end if;
-- USER
begin
l_user := SYS_CONTEXT('USERENV', 'SESSION_USER');
if l_user is null then
l_user := 'UNKNOWN';
end if;
exception when others then
l_user := 'UNKNOWN';
end;
-- OSUSER
begin
l_osuser := SYS_CONTEXT('USERENV', 'OS_USER');
if l_osuser is null then
l_osuser := 'UNKNOWN';
end if;
exception when others then
l_osuser := 'UNKNOWN';
end;
-- HOST
begin
l_host := SYS_CONTEXT('USERENV', 'HOST');
if l_host is null then
l_host := 'UNKNOWN';
end if;
exception when others then
l_host := 'UNKNOWN';
end;
-- MODULE
begin
l_module := SYS_CONTEXT('USERENV', 'MODULE');
if l_module is null then
l_module := 'NULL';
end if;
exception when others then
l_module := 'UNKNOWN';
end;
-- ACTION
begin
l_action := SYS_CONTEXT('USERENV', 'ACTION');
if l_action is null then
l_action := 'NULL';
end if;
exception when others then
l_action := 'UNKNOWN';
end;
-- CLIENT INFO
begin
l_client_info := SYS_CONTEXT('USERENV', 'CLIENT_INFO');
if l_client_info is null then
l_client_info := 'NULL';
end if;
exception when others then
l_client_info := 'UNKNOWN';
end;
-- SID
begin
l_sid := SYS_CONTEXT('USERENV', 'SID');
if l_sid is null then
l_sid := 'UNKNOWN';
end if;
exception when others then
l_sid := 'UNKNOWN';
end;
-- LOGGING
-- main information
l_message_text := case when :new.av_cost is NULL then 'av_cost is NULL'
else 'av_cost = ' || to_char(:new.av_cost)
end ||
case when l_dml_type = 'INSERT' then NULL
else case when :old.av_cost is NULL then ', old av_cost is NULL'
else ', old av_cost = ' || to_char(:old.av_cost)
end
end ||
', operation - ' || l_dml_type;
xxlm_sql.write_debug_info(pi_program_name => c_program
,pi_message_text => l_message_text
,pi_event_name => c_event_name);
xxlm_sql.write_debug_info(pi_program_name => c_program
,pi_message_text => 'Item = ' || :new.item || ', location = ' || to_char(:new.loc)
|| ', loc_type = ' || :new.loc_type
|| case when :old.av_cost is not NULL then ', old av_cost = ' || to_char(:old.av_cost)
else NULL end
,pi_event_name => c_event_name);
-- additional information
xxlm_sql.write_debug_info(pi_program_name => c_program
,pi_message_text => 'User = ' || l_user || ', ' ||
'OS User = ' || l_osuser || ', ' ||
'Host = ' || l_host
,pi_event_name => c_event_name);
xxlm_sql.write_debug_info(pi_program_name => c_program
,pi_message_text => 'SID = ' || l_sid || ', ' ||
'Module = ' || l_module || ', ' ||
'Action = ' || l_action || ', ' ||
'Client info = ' || l_client_info
,pi_event_name => c_event_name);
exception when others then
xxlm_sql.write_debug_info(pi_program_name => c_program
,pi_message_text => 'Exception: ' || SQLERRM
,pi_event_name => c_event_name);
end XXLM_RMS_ITEM_LOC_SOH_AIU_2;
/
ALTER TRIGGER "RMS"."XXLM_RMS_ITEM_LOC_SOH_AIU_2" ENABLE;
CREATE OR REPLACE TRIGGER "RMS"."RMS_ITEM_LOC_SOH_AU"
BEFORE UPDATE OR INSERT OR DELETE
ON ITEM_LOC_SOH
FOR EACH ROW
DECLARE
name VARCHAR2(30);
sys_date date;
change_flag VARCHAR2(1);
BEGIN
name := USER;
sys_date := SYSDATE;
if INSERTING OR UPDATING then
if INSERTING then
change_flag := 'I';
insert into RMS.ITEM_LOC_SOH_AU values( :new.ITEM, :new.ITEM, :old.ITEM, :new.LOC, :new.LOC, :old.LOC, :new.QTY_RECEIVED, :old.QTY_RECEIVED, :new.QTY_SOLD, :old.QTY_SOLD, :new.RTV_QTY, :old.RTV_QTY, :new.STOCK_ON_HAND, :old.STOCK_ON_HAND, :new.TSF_RESERVED_QTY, :old.TSF_RESERVED_QTY, :new.UNIT_COST, :old.UNIT_COST, NAME, SYS_DATE, CHANGE_FLAG);
else change_flag := 'U';
if (nvl(:new.ITEM,' ') != nvl(:old.ITEM,' '))
or (nvl(:new.LOC,-999) != nvl(:old.LOC,-999))
or (nvl(:new.QTY_RECEIVED,-999) != nvl(:old.QTY_RECEIVED,-999))
or (nvl(:new.QTY_SOLD,-999) != nvl(:old.QTY_SOLD,-999))
or (nvl(:new.RTV_QTY,-999) != nvl(:old.RTV_QTY,-999))
or (nvl(:new.STOCK_ON_HAND,-999) != nvl(:old.STOCK_ON_HAND,-999))
or (nvl(:new.TSF_RESERVED_QTY,-999) != nvl(:old.TSF_RESERVED_QTY,-999))
or (nvl(:new.UNIT_COST,-999) != nvl(:old.UNIT_COST,-999))
then
insert into RMS.ITEM_LOC_SOH_AU values( :new.ITEM, :new.ITEM, :old.ITEM, :new.LOC, :new.LOC, :old.LOC, :new.QTY_RECEIVED, :old.QTY_RECEIVED, :new.QTY_SOLD, :old.QTY_SOLD, :new.RTV_QTY, :old.RTV_QTY, :new.STOCK_ON_HAND, :old.STOCK_ON_HAND, :new.TSF_RESERVED_QTY, :old.TSF_RESERVED_QTY, :new.UNIT_COST, :old.UNIT_COST, NAME, SYS_DATE, CHANGE_FLAG);
end if;
end if;
else
change_flag := 'D';
insert into RMS.ITEM_LOC_SOH_AU ( ITEM, OLD_ITEM, LOC, OLD_LOC, OLD_QTY_RECEIVED, OLD_QTY_SOLD, OLD_RTV_QTY, OLD_STOCK_ON_HAND, OLD_TSF_RESERVED_QTY, OLD_UNIT_COST, USER_ID, MODIFY_DATE, CHANGE_TYPE) values( :old.ITEM, :old.ITEM, :old.LOC, :old.LOC, :old.QTY_RECEIVED, :old.QTY_SOLD, :old.RTV_QTY, :old.STOCK_ON_HAND, :old.TSF_RESERVED_QTY, :old.UNIT_COST, NAME, SYS_DATE, CHANGE_FLAG);
end if;
end;
/
ALTER TRIGGER "RMS"."RMS_ITEM_LOC_SOH_AU" ENABLE;
CREATE OR REPLACE TRIGGER "RMS"."XXLM_ITEM_LOC_SOH_247"
AFTER INSERT OR UPDATE OR DELETE OF STOCK_ON_HAND
ON ITEM_LOC_SOH
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
-- version 1.000 01.06.2016
-- Author: Alexander Tribrat
-- Creation date: 2016-06-01
-- RICEFW Object: IF.247
-- Dependencies:
-- Description:
-- Modification History:
-- 1.0 2012-08-07 Alexander Tribrat initial version
-- 1.1 2016-10-17 Mikhail Pershin additional exit conditions
langSqlCode NUMBER;
ErrorMessage VARCHAR2(500);
v_item ITEM_MASTER.ITEM%TYPE;
v_action XXLM_RMS_ITEM_MASTER_DATA_PKG.C_INSERT%TYPE;
l_program_name VARCHAR2(100) := SUBSTRB('TRIGGER XXLM_ITEM_LOC_SOH_247', 1, 100);
l_count NUMBER;
BEGIN
---<1.1>--
IF updating AND :new.stock_on_hand = :old.stock_on_hand
THEN
RETURN;
END IF;
--/<1.1>--
IF DELETING THEN
V_ITEM := :OLD.ITEM;
v_action := XXLM_RMS_ITEM_MASTER_DATA_PKG.C_UPDATE;
ELSE
V_ITEM := :NEW.ITEM;
IF INSERTING THEN
v_action := XXLM_RMS_ITEM_MASTER_DATA_PKG.C_INSERT;
ELSE
v_action := XXLM_RMS_ITEM_MASTER_DATA_PKG.C_UPDATE;
END IF;
END IF;
IF (NOT XXLM_RMS_ITEM_MASTER_DATA_PKG.CHECK_AVALIABLE_DATA (v_item)) THEN
return;
END IF;
SELECT COUNT(*)
INTO l_count
FROM XXLM_RU_ARTCOM_CREMODSUPP
WHERE NUM_ART = V_ITEM
AND EXTRACTED_IND IN ('N', 'E')
AND EVENT_ID != 4; -- 1.1
IF l_count = 0 THEN
INSERT INTO XXLM_RU_ARTCOM_CREMODSUPP (NUM_ART, DATE_EVT, EVENT_ID, EXTRACTED_IND)
VALUES (V_ITEM, SYSDATE, V_ACTION, 'N');
/* ELSE
UPDATE XXLM_RU_ARTCOM_CREMODSUPP
SET EVENT_ID = V_ACTION,
DATE_EVT = SYSDATE,
EXTRACTED_IND = 'N'
WHERE NUM_ART = V_ITEM
AND EXTRACTED_IND IN ('N', 'E')
and event_id != 4; -- 1.2 */
END IF;
EXCEPTION
WHEN OTHERS THEN
ErrorMessage := SUBSTR(SQLERRM,1,200);
langSqlCode := SQLCODE;
INSERT INTO if_errors (PROGRAM_NAME, ERR_DATE, UNIT_OF_WORK, ERROR)
VALUES (l_program_name,
SYSDATE,
'Item - ' || V_ITEM,
'Error code: ' || langSqlCode
|| '; Message: ' || ErrorMessage );
END;
/
ALTER TRIGGER "RMS"."XXLM_ITEM_LOC_SOH_247" DISABLE;
CREATE OR REPLACE TRIGGER "RMS"."XXLM_RMS_ITEM_LOC_SOH_AIUD"
AFTER DELETE OR INSERT OR UPDATE
OF STOCK_ON_HAND
ON ITEM_LOC_SOH
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
-- Author: Pavel Filimonov
-- Creation date: 2012-07-12
-- RICEFW Object: IF.022
-- Dependencies:
-- Description: Interface Item supplier
-- Modification History:
-- <2.005> <2013-04-17> <Yuri Volushkov>
-- <2.006> <2013-12-06> <Yuri Volushkov> M 1213
-- <2.008> <2014-02-18> <Yuri Volushkov> M 1876
langSqlCode NUMBER;
ErrorMessage VARCHAR2(500);
v_item ITEM_LOC_SOH.ITEM%TYPE;
v_loc ITEM_LOC_SOH.LOC%TYPE;
v_item_parent ITEM_MASTER.ITEM_PARENT%TYPE;
v_count NUMBER;
l_program varchar2(250) := 'XXLM_RMS_ITEM_LOC_SOH_AIUD';
-- YV 2014-01-24
v_loc_type item_loc_soh.loc_type%TYPE; -- varchar2(1)
-- YV 2014-02-18 M1876
duplicate_record EXCEPTION;
PRAGMA EXCEPTION_INIT(duplicate_record, -20990);
BEGIN
IF deleting THEN
V_ITEM := :OLD.ITEM;
V_LOC := :OLD.LOC;
v_loc_type := :old.loc_type;
ELSE
V_ITEM := :NEW.ITEM;
V_LOC := :NEW.LOC;
v_loc_type := :new.loc_type;
END IF;
-- YV 2014-01-24
IF v_loc = 1 THEN
RETURN;
END IF;
-- check STOCK_ON_HAND
IF updating
AND :new.stock_on_hand = :old.stock_on_hand
THEN
RETURN;
END IF;
if v_loc_type != 'S' then
return;
end if;
BEGIN
SELECT ITEM INTO V_ITEM FROM ITEM_MASTER
WHERE ITEM = V_ITEM
AND PACK_IND = 'N' ;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN;
END;
SELECT count(*) INTO v_count FROM ITEM_MASTER
WHERE ITEM = V_ITEM
AND ITEM_LEVEL = 1
AND TRAN_LEVEL IN (1,2);
IF (v_count = 0) THEN
BEGIN
SELECT item_parent INTO v_item_parent FROM ITEM_MASTER t
WHERE ITEM = V_ITEM
AND item_parent IN (
SELECT ITEM FROM ITEM_MASTER
WHERE ITEM_LEVEL = 1
AND ITEM = t.item_parent
AND TRAN_LEVEL = 2);
V_ITEM := V_ITEM_PARENT;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN;
END;
END IF;
-- YV 2014-02-19 M1876
insert into xxlm_item_status(item
,store
,extracted_ind
,delete_ind
,creation_pgm)
values(v_item
,v_loc
,'N'
,'N'
,l_program);
exception
WHEN duplicate_record THEN
NULL;
WHEN OTHERS THEN
ErrorMessage := SUBSTR(SQLERRM,1,500);
langSqlCode := SQLCODE;
INSERT INTO if_errors (PROGRAM_NAME, ERR_DATE, UNIT_OF_WORK, ERROR)
VALUES (l_program,
SYSDATE,
'Item - ' || V_ITEM || '; Loc - ' || V_LOC,
'Error code: ' || langSqlCode
|| '; Message: ' || ErrorMessage );
END;
/
ALTER TRIGGER "RMS"."XXLM_RMS_ITEM_LOC_SOH_AIUD" ENABLE;
CREATE TABLE "RMS"."ITEM_LOC_HIST"
( "ITEM" VARCHAR2(25 BYTE) NOT NULL ENABLE,
"LOC" NUMBER(10,0) NOT NULL ENABLE,
"LOC_TYPE" VARCHAR2(1 BYTE) NOT NULL ENABLE,
"EOW_DATE" DATE NOT NULL ENABLE,
"WEEK_454" NUMBER(2,0),
"MONTH_454" NUMBER(2,0),
"YEAR_454" NUMBER(4,0),
"SALES_TYPE" VARCHAR2(1 BYTE) NOT NULL ENABLE,
"SALES_ISSUES" NUMBER(12,4),
"VALUE" NUMBER(20,4),
"GP" NUMBER(20,4),
"STOCK" NUMBER(12,4),
"RETAIL" NUMBER(20,4),
"AV_COST" NUMBER(20,4),
"CREATE_DATETIME" DATE NOT NULL ENABLE,
"LAST_UPDATE_DATETIME" DATE NOT NULL ENABLE,
"LAST_UPDATE_ID" VARCHAR2(30 BYTE) NOT NULL ENABLE,
CONSTRAINT "PK_ITEM_LOC_HIST" PRIMARY KEY ("ITEM", "SALES_TYPE", "LOC", "EOW_DATE")
USING INDEX PCTFREE 10 INITRANS 12 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_INDEX" ENABLE,
CONSTRAINT "CHK_ITEM_HIST_SALES_TYPE" CHECK (SALES_TYPE in ('R', 'P', 'C', 'I')) ENABLE,
CONSTRAINT "CHK_ITEM_LOC_HIST_LOC_TYPE" CHECK (LOC_TYPE in ('S', 'W')) ENABLE
) PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA"
PARTITION BY RANGE ("EOW_DATE")
SUBPARTITION BY HASH ("LOC")
SUBPARTITION TEMPLATE (
SUBPARTITION "S001"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S002"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S003"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S004"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S005"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S006"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S007"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S008"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S009"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S010"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S011"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S012"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S013"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S014"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S015"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S016"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S017"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S018"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S019"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S020"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S021"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S022"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S023"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S024"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S025"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S026"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S027"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S028"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S029"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S030"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S031"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S032"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S033"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S034"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S035"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S036"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S037"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S038"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S039"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S040"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S041"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S042"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S043"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S044"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S045"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S046"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S047"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S048"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S049"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S050"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S051"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S052"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S053"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S054"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S055"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S056"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S057"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S058"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S059"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S060"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S061"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S062"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S063"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S064"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S065"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S066"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S067"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S068"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S069"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S070"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S071"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S072"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S073"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S074"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S075"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S076"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S077"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S078"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S079"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S080"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S081"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S082"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S083"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S084"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S085"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S086"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S087"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S088"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S089"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S090"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S091"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S092"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S093"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S094"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S095"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S096"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S097"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S098"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S099"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S100"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S101"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S102"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S103"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S104"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S105"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S106"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S107"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S108"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S109"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S110"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S111"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S112"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S113"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S114"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S115"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S116"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S117"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S118"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S119"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S120"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S121"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S122"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S123"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S124"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S125"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S126"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S127"
TABLESPACE "RETEK_DATA" ,
SUBPARTITION "S128"
TABLESPACE "RETEK_DATA" )
(PARTITION "ITEM_LOC_HIST_P1" VALUES LESS THAN (TO_DATE(' 2013-07-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P2" VALUES LESS THAN (TO_DATE(' 2013-08-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P3" VALUES LESS THAN (TO_DATE(' 2013-09-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P4" VALUES LESS THAN (TO_DATE(' 2013-10-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P5" VALUES LESS THAN (TO_DATE(' 2013-10-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P6" VALUES LESS THAN (TO_DATE(' 2013-10-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P7" VALUES LESS THAN (TO_DATE(' 2013-10-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P8" VALUES LESS THAN (TO_DATE(' 2013-11-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P9" VALUES LESS THAN (TO_DATE(' 2013-11-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P10" VALUES LESS THAN (TO_DATE(' 2013-11-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P11" VALUES LESS THAN (TO_DATE(' 2013-11-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P12" VALUES LESS THAN (TO_DATE(' 2013-12-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P13" VALUES LESS THAN (TO_DATE(' 2013-12-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P14" VALUES LESS THAN (TO_DATE(' 2013-12-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P15" VALUES LESS THAN (TO_DATE(' 2013-12-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P16" VALUES LESS THAN (TO_DATE(' 2013-12-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P17" VALUES LESS THAN (TO_DATE(' 2014-01-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P18" VALUES LESS THAN (TO_DATE(' 2014-01-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P19" VALUES LESS THAN (TO_DATE(' 2014-01-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P20" VALUES LESS THAN (TO_DATE(' 2014-01-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P21" VALUES LESS THAN (TO_DATE(' 2014-02-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P22" VALUES LESS THAN (TO_DATE(' 2014-02-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P23" VALUES LESS THAN (TO_DATE(' 2014-02-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P24" VALUES LESS THAN (TO_DATE(' 2014-02-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P25" VALUES LESS THAN (TO_DATE(' 2014-03-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P26" VALUES LESS THAN (TO_DATE(' 2014-03-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P27" VALUES LESS THAN (TO_DATE(' 2014-03-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P28" VALUES LESS THAN (TO_DATE(' 2014-03-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P29" VALUES LESS THAN (TO_DATE(' 2014-03-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P30" VALUES LESS THAN (TO_DATE(' 2014-04-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P31" VALUES LESS THAN (TO_DATE(' 2014-04-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P32" VALUES LESS THAN (TO_DATE(' 2014-04-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P33" VALUES LESS THAN (TO_DATE(' 2014-04-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P34" VALUES LESS THAN (TO_DATE(' 2014-05-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P35" VALUES LESS THAN (TO_DATE(' 2014-05-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P36" VALUES LESS THAN (TO_DATE(' 2014-05-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P37" VALUES LESS THAN (TO_DATE(' 2014-05-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P38" VALUES LESS THAN (TO_DATE(' 2014-06-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P39" VALUES LESS THAN (TO_DATE(' 2014-06-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P40" VALUES LESS THAN (TO_DATE(' 2014-06-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P41" VALUES LESS THAN (TO_DATE(' 2014-06-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P42" VALUES LESS THAN (TO_DATE(' 2014-06-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P43" VALUES LESS THAN (TO_DATE(' 2014-07-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P44" VALUES LESS THAN (TO_DATE(' 2014-07-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P45" VALUES LESS THAN (TO_DATE(' 2014-07-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P46" VALUES LESS THAN (TO_DATE(' 2014-07-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P47" VALUES LESS THAN (TO_DATE(' 2014-08-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P48" VALUES LESS THAN (TO_DATE(' 2014-08-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P49" VALUES LESS THAN (TO_DATE(' 2014-08-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P50" VALUES LESS THAN (TO_DATE(' 2014-08-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P51" VALUES LESS THAN (TO_DATE(' 2014-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P52" VALUES LESS THAN (TO_DATE(' 2014-09-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P53" VALUES LESS THAN (TO_DATE(' 2014-09-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P54" VALUES LESS THAN (TO_DATE(' 2014-09-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P55" VALUES LESS THAN (TO_DATE(' 2014-09-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P56" VALUES LESS THAN (TO_DATE(' 2014-10-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P57" VALUES LESS THAN (TO_DATE(' 2014-10-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P58" VALUES LESS THAN (TO_DATE(' 2014-10-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P59" VALUES LESS THAN (TO_DATE(' 2014-10-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P60" VALUES LESS THAN (TO_DATE(' 2014-11-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P61" VALUES LESS THAN (TO_DATE(' 2014-11-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P62" VALUES LESS THAN (TO_DATE(' 2014-11-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P63" VALUES LESS THAN (TO_DATE(' 2014-11-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P64" VALUES LESS THAN (TO_DATE(' 2014-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P65" VALUES LESS THAN (TO_DATE(' 2014-12-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P66" VALUES LESS THAN (TO_DATE(' 2014-12-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P67" VALUES LESS THAN (TO_DATE(' 2014-12-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P68" VALUES LESS THAN (TO_DATE(' 2014-12-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P69" VALUES LESS THAN (TO_DATE(' 2015-01-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P70" VALUES LESS THAN (TO_DATE(' 2015-01-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P71" VALUES LESS THAN (TO_DATE(' 2015-01-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P72" VALUES LESS THAN (TO_DATE(' 2015-01-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P73" VALUES LESS THAN (TO_DATE(' 2015-02-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P74" VALUES LESS THAN (TO_DATE(' 2015-02-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P75" VALUES LESS THAN (TO_DATE(' 2015-02-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P76" VALUES LESS THAN (TO_DATE(' 2015-02-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P77" VALUES LESS THAN (TO_DATE(' 2015-03-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P78" VALUES LESS THAN (TO_DATE(' 2015-03-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P79" VALUES LESS THAN (TO_DATE(' 2015-03-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P80" VALUES LESS THAN (TO_DATE(' 2015-03-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P81" VALUES LESS THAN (TO_DATE(' 2015-03-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P82" VALUES LESS THAN (TO_DATE(' 2015-04-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P83" VALUES LESS THAN (TO_DATE(' 2015-04-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P84" VALUES LESS THAN (TO_DATE(' 2015-04-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P85" VALUES LESS THAN (TO_DATE(' 2015-04-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P86" VALUES LESS THAN (TO_DATE(' 2015-05-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P87" VALUES LESS THAN (TO_DATE(' 2015-05-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P88" VALUES LESS THAN (TO_DATE(' 2015-05-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P89" VALUES LESS THAN (TO_DATE(' 2015-05-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P90" VALUES LESS THAN (TO_DATE(' 2015-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P91" VALUES LESS THAN (TO_DATE(' 2015-06-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P92" VALUES LESS THAN (TO_DATE(' 2015-06-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P93" VALUES LESS THAN (TO_DATE(' 2015-06-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P94" VALUES LESS THAN (TO_DATE(' 2015-06-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P95" VALUES LESS THAN (TO_DATE(' 2015-07-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P96" VALUES LESS THAN (TO_DATE(' 2015-07-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P97" VALUES LESS THAN (TO_DATE(' 2015-07-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P98" VALUES LESS THAN (TO_DATE(' 2015-07-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P99" VALUES LESS THAN (TO_DATE(' 2015-08-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P100" VALUES LESS THAN (TO_DATE(' 2015-08-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P101" VALUES LESS THAN (TO_DATE(' 2015-08-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P102" VALUES LESS THAN (TO_DATE(' 2015-08-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P103" VALUES LESS THAN (TO_DATE(' 2015-08-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P104" VALUES LESS THAN (TO_DATE(' 2015-09-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P105" VALUES LESS THAN (TO_DATE(' 2015-09-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P106" VALUES LESS THAN (TO_DATE(' 2015-09-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P107" VALUES LESS THAN (TO_DATE(' 2015-09-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P108" VALUES LESS THAN (TO_DATE(' 2015-10-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P109" VALUES LESS THAN (TO_DATE(' 2015-10-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P110" VALUES LESS THAN (TO_DATE(' 2015-10-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P111" VALUES LESS THAN (TO_DATE(' 2015-10-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P112" VALUES LESS THAN (TO_DATE(' 2015-11-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P113" VALUES LESS THAN (TO_DATE(' 2015-11-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P114" VALUES LESS THAN (TO_DATE(' 2015-11-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P115" VALUES LESS THAN (TO_DATE(' 2015-11-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P116" VALUES LESS THAN (TO_DATE(' 2015-11-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P117" VALUES LESS THAN (TO_DATE(' 2015-12-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P118" VALUES LESS THAN (TO_DATE(' 2015-12-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P119" VALUES LESS THAN (TO_DATE(' 2015-12-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P120" VALUES LESS THAN (TO_DATE(' 2015-12-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P121" VALUES LESS THAN (TO_DATE(' 2016-01-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P122" VALUES LESS THAN (TO_DATE(' 2016-01-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P123" VALUES LESS THAN (TO_DATE(' 2016-01-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P124" VALUES LESS THAN (TO_DATE(' 2016-01-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P125" VALUES LESS THAN (TO_DATE(' 2016-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P126" VALUES LESS THAN (TO_DATE(' 2016-02-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P127" VALUES LESS THAN (TO_DATE(' 2016-02-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P128" VALUES LESS THAN (TO_DATE(' 2016-02-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P129" VALUES LESS THAN (TO_DATE(' 2016-02-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P130" VALUES LESS THAN (TO_DATE(' 2016-03-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P131" VALUES LESS THAN (TO_DATE(' 2016-03-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P132" VALUES LESS THAN (TO_DATE(' 2016-03-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P133" VALUES LESS THAN (TO_DATE(' 2016-03-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P134" VALUES LESS THAN (TO_DATE(' 2016-04-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P135" VALUES LESS THAN (TO_DATE(' 2016-04-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P136" VALUES LESS THAN (TO_DATE(' 2016-04-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P137" VALUES LESS THAN (TO_DATE(' 2016-04-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P138" VALUES LESS THAN (TO_DATE(' 2016-05-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P139" VALUES LESS THAN (TO_DATE(' 2016-05-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P140" VALUES LESS THAN (TO_DATE(' 2016-05-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P141" VALUES LESS THAN (TO_DATE(' 2016-05-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P142" VALUES LESS THAN (TO_DATE(' 2016-05-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P143" VALUES LESS THAN (TO_DATE(' 2016-06-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P144" VALUES LESS THAN (TO_DATE(' 2016-06-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P145" VALUES LESS THAN (TO_DATE(' 2016-06-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P146" VALUES LESS THAN (TO_DATE(' 2016-06-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P147" VALUES LESS THAN (TO_DATE(' 2016-07-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P148" VALUES LESS THAN (TO_DATE(' 2016-07-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P149" VALUES LESS THAN (TO_DATE(' 2016-07-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P150" VALUES LESS THAN (TO_DATE(' 2016-07-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P151" VALUES LESS THAN (TO_DATE(' 2016-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P152" VALUES LESS THAN (TO_DATE(' 2016-08-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P153" VALUES LESS THAN (TO_DATE(' 2016-08-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P154" VALUES LESS THAN (TO_DATE(' 2016-08-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P155" VALUES LESS THAN (TO_DATE(' 2016-08-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P156" VALUES LESS THAN (TO_DATE(' 2016-09-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P157" VALUES LESS THAN (TO_DATE(' 2016-09-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P158" VALUES LESS THAN (TO_DATE(' 2016-09-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P159" VALUES LESS THAN (TO_DATE(' 2016-09-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P160" VALUES LESS THAN (TO_DATE(' 2016-10-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P161" VALUES LESS THAN (TO_DATE(' 2016-10-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P162" VALUES LESS THAN (TO_DATE(' 2016-10-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P163" VALUES LESS THAN (TO_DATE(' 2016-10-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P164" VALUES LESS THAN (TO_DATE(' 2016-10-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P165" VALUES LESS THAN (TO_DATE(' 2016-11-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P166" VALUES LESS THAN (TO_DATE(' 2016-11-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P167" VALUES LESS THAN (TO_DATE(' 2016-11-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P168" VALUES LESS THAN (TO_DATE(' 2016-11-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P169" VALUES LESS THAN (TO_DATE(' 2016-12-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P170" VALUES LESS THAN (TO_DATE(' 2016-12-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P171" VALUES LESS THAN (TO_DATE(' 2016-12-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P172" VALUES LESS THAN (TO_DATE(' 2016-12-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P173" VALUES LESS THAN (TO_DATE(' 2017-01-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P174" VALUES LESS THAN (TO_DATE(' 2017-01-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P175" VALUES LESS THAN (TO_DATE(' 2017-01-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P176" VALUES LESS THAN (TO_DATE(' 2017-01-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P177" VALUES LESS THAN (TO_DATE(' 2017-01-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P178" VALUES LESS THAN (TO_DATE(' 2017-02-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P179" VALUES LESS THAN (TO_DATE(' 2017-02-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P180" VALUES LESS THAN (TO_DATE(' 2017-02-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P181" VALUES LESS THAN (TO_DATE(' 2017-02-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P182" VALUES LESS THAN (TO_DATE(' 2017-03-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P183" VALUES LESS THAN (TO_DATE(' 2017-03-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P184" VALUES LESS THAN (TO_DATE(' 2017-03-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P185" VALUES LESS THAN (TO_DATE(' 2017-03-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P186" VALUES LESS THAN (TO_DATE(' 2017-04-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P187" VALUES LESS THAN (TO_DATE(' 2017-04-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P188" VALUES LESS THAN (TO_DATE(' 2017-04-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P189" VALUES LESS THAN (TO_DATE(' 2017-04-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P190" VALUES LESS THAN (TO_DATE(' 2017-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P191" VALUES LESS THAN (TO_DATE(' 2017-05-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P192" VALUES LESS THAN (TO_DATE(' 2017-05-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P193" VALUES LESS THAN (TO_DATE(' 2017-05-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P194" VALUES LESS THAN (TO_DATE(' 2017-05-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P195" VALUES LESS THAN (TO_DATE(' 2017-06-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P196" VALUES LESS THAN (TO_DATE(' 2017-06-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P197" VALUES LESS THAN (TO_DATE(' 2017-06-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P198" VALUES LESS THAN (TO_DATE(' 2017-06-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P199" VALUES LESS THAN (TO_DATE(' 2017-07-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P200" VALUES LESS THAN (TO_DATE(' 2017-07-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P201" VALUES LESS THAN (TO_DATE(' 2017-07-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P202" VALUES LESS THAN (TO_DATE(' 2017-07-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P203" VALUES LESS THAN (TO_DATE(' 2017-07-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P204" VALUES LESS THAN (TO_DATE(' 2017-08-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P205" VALUES LESS THAN (TO_DATE(' 2017-08-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P206" VALUES LESS THAN (TO_DATE(' 2017-08-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P207" VALUES LESS THAN (TO_DATE(' 2017-08-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P208" VALUES LESS THAN (TO_DATE(' 2017-09-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P209" VALUES LESS THAN (TO_DATE(' 2017-09-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P210" VALUES LESS THAN (TO_DATE(' 2017-09-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P211" VALUES LESS THAN (TO_DATE(' 2017-09-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P212" VALUES LESS THAN (TO_DATE(' 2017-10-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P213" VALUES LESS THAN (TO_DATE(' 2017-10-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P214" VALUES LESS THAN (TO_DATE(' 2017-10-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P215" VALUES LESS THAN (TO_DATE(' 2017-10-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P216" VALUES LESS THAN (TO_DATE(' 2017-10-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P217" VALUES LESS THAN (TO_DATE(' 2017-11-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P218" VALUES LESS THAN (TO_DATE(' 2017-11-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P219" VALUES LESS THAN (TO_DATE(' 2017-11-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P220" VALUES LESS THAN (TO_DATE(' 2017-11-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P221" VALUES LESS THAN (TO_DATE(' 2017-12-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P222" VALUES LESS THAN (TO_DATE(' 2017-12-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P223" VALUES LESS THAN (TO_DATE(' 2017-12-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P224" VALUES LESS THAN (TO_DATE(' 2017-12-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P225" VALUES LESS THAN (TO_DATE(' 2018-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P226" VALUES LESS THAN (TO_DATE(' 2018-01-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P227" VALUES LESS THAN (TO_DATE(' 2018-01-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P228" VALUES LESS THAN (TO_DATE(' 2018-01-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P229" VALUES LESS THAN (TO_DATE(' 2018-01-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P230" VALUES LESS THAN (TO_DATE(' 2018-02-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P231" VALUES LESS THAN (TO_DATE(' 2018-02-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P232" VALUES LESS THAN (TO_DATE(' 2018-02-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P233" VALUES LESS THAN (TO_DATE(' 2018-02-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P234" VALUES LESS THAN (TO_DATE(' 2018-03-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P235" VALUES LESS THAN (TO_DATE(' 2018-03-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P236" VALUES LESS THAN (TO_DATE(' 2018-03-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P237" VALUES LESS THAN (TO_DATE(' 2018-03-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P238" VALUES LESS THAN (TO_DATE(' 2018-04-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P239" VALUES LESS THAN (TO_DATE(' 2018-04-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P240" VALUES LESS THAN (TO_DATE(' 2018-04-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P241" VALUES LESS THAN (TO_DATE(' 2018-04-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P242" VALUES LESS THAN (TO_DATE(' 2018-04-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P243" VALUES LESS THAN (TO_DATE(' 2018-05-07 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P244" VALUES LESS THAN (TO_DATE(' 2018-05-14 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P245" VALUES LESS THAN (TO_DATE(' 2018-05-21 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P246" VALUES LESS THAN (TO_DATE(' 2018-05-28 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P247" VALUES LESS THAN (TO_DATE(' 2018-06-04 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P248" VALUES LESS THAN (TO_DATE(' 2018-06-11 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P249" VALUES LESS THAN (TO_DATE(' 2018-06-18 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P250" VALUES LESS THAN (TO_DATE(' 2018-06-25 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P251" VALUES LESS THAN (TO_DATE(' 2018-07-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P252" VALUES LESS THAN (TO_DATE(' 2018-07-09 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P253" VALUES LESS THAN (TO_DATE(' 2018-07-16 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P254" VALUES LESS THAN (TO_DATE(' 2018-07-23 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P255" VALUES LESS THAN (TO_DATE(' 2018-07-30 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P256" VALUES LESS THAN (TO_DATE(' 2018-08-06 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P257" VALUES LESS THAN (TO_DATE(' 2018-08-13 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P258" VALUES LESS THAN (TO_DATE(' 2018-08-20 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P259" VALUES LESS THAN (TO_DATE(' 2018-08-27 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P260" VALUES LESS THAN (TO_DATE(' 2018-09-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P261" VALUES LESS THAN (TO_DATE(' 2018-09-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P262" VALUES LESS THAN (TO_DATE(' 2018-09-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P263" VALUES LESS THAN (TO_DATE(' 2018-09-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P264" VALUES LESS THAN (TO_DATE(' 2018-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P265" VALUES LESS THAN (TO_DATE(' 2018-10-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P266" VALUES LESS THAN (TO_DATE(' 2018-10-15 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P267" VALUES LESS THAN (TO_DATE(' 2018-10-22 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P268" VALUES LESS THAN (TO_DATE(' 2018-10-29 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P269" VALUES LESS THAN (TO_DATE(' 2018-11-05 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P270" VALUES LESS THAN (TO_DATE(' 2018-11-12 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P271" VALUES LESS THAN (TO_DATE(' 2018-11-19 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P272" VALUES LESS THAN (TO_DATE(' 2018-11-26 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P273" VALUES LESS THAN (TO_DATE(' 2018-12-03 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P274" VALUES LESS THAN (TO_DATE(' 2018-12-10 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P275" VALUES LESS THAN (TO_DATE(' 2018-12-17 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P276" VALUES LESS THAN (TO_DATE(' 2018-12-24 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_P277" VALUES LESS THAN (TO_DATE(' 2018-12-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ,
PARTITION "ITEM_LOC_HIST_MAX" VALUES LESS THAN (MAXVALUE)
PCTFREE 10 PCTUSED 40 INITRANS 6 MAXTRANS 255
STORAGE(
FREELISTS 6
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_DATA" ) ;
COMMENT ON TABLE "RMS"."ITEM_LOC_HIST" IS 'PARTITION BY RANGE (EOW_DATE), SUBPARTITION BY HASH (LOC), LOCAL PK';
CREATE INDEX "RMS"."ITEM_LOC_HIST_I1" ON "RMS"."ITEM_LOC_HIST" ("ITEM", "EOW_DATE")
PCTFREE 20 INITRANS 12 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_INDEX" ;
CREATE INDEX "RMS"."ITEM_LOC_HIST_I2" ON "RMS"."ITEM_LOC_HIST" ("LOC")
PCTFREE 10 INITRANS 12 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "RETEK_INDEX"
PARALLEL 3 ;
Π ΡΠ°ΠΌ ΡΠΊΡΠΈΠΏΡ
SELECT DISTINCT
CASE WHEN LENGTH (item_master.DEPT)<4 THEN SUBSTR (item_master.dept, 1, 1) ELSE SUBSTR (item_master.dept, 1, 2) END AS ΠΎΡΠ΄Π΅Π», --Π€ΠΎΡΠΌΡΠ»Π° ΠΎΡΠ΄Π΅Π»Π°
item_master.DEPT AS ΠΠΎΠ΄ΠΎΡΠ΄Π΅Π»,
item_master.CLASS AS Π’ΠΈΠΏ,
item_master.SUBCLASS AS ΠΠΎΠ΄ΡΠΈΠΏ,
item_loc_soh.ITEM AS ΠΡΡΠΈΠΊΡΠ»,
item_master.ITEM_DESC AS ΠΠ°ΠΈΠΌ_Π°ΡΡΠΈΠΊΡΠ»Π°,
(item_loc_soh.STOCK_ON_HAND - item_loc_soh.NON_SELLABLE_QTY - item_loc_soh.TSF_RESERVED_QTY - item_loc_soh.RTV_QTY) AS ΠΠ°ΠΏΠ°Ρ_62,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE LOC IN ('2') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60 GROUP BY item) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_2,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE LOC IN ('3') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60 GROUP BY item) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_3,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('4') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_4,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('5') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_5,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('6') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_6,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('20') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_20,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('22') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_22,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('26') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_26,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('28') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_28,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('32') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_32,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('35') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_35,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('40') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_40,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('43') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_43,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('49') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_49,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('51') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_51,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('56') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_56,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('62') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_62,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('65') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_65,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('86') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_86,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('114') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_114,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('117') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_117,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('122') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_122,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('143') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_143,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('153') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_153,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('169') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_169,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('251') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_251,
(SELECT SUM (SALES_ISSUES) FROM ITEM_LOC_HIST WHERE ITEM_LOC_HIST.ITEM=item_loc_soh.ITEM AND LOC IN ('252') AND ITEM_LOC_HIST.LAST_UPDATE_DATETIME >= sysdate-60) AS ΠΡΠΎΠ΄Π°ΠΆΠΈ_252
FROM ITEM_LOC_SOH
INNER JOIN ITEM_MASTER ON ITEM_MASTER.ITEM = ITEM_LOC_SOH.ITEM
INNER JOIN ITEM_LOC_HIST ON ITEM_LOC_HIST.ITEM = ITEM_LOC_SOH.ITEM
WHERE --CASE WHEN LENGTH (item_master.DEPT)<4 THEN SUBSTR (item_master.dept, 1, 1) ELSE SUBSTR (item_master.dept, 1, 2) END IN ('1') and
(item_loc_soh.STOCK_ON_HAND - item_loc_soh.NON_SELLABLE_QTY - item_loc_soh.TSF_RESERVED_QTY - item_loc_soh.RTV_QTY) > 0 AND
--item_loc_soh.ITEM IN ('675547') AND
item_loc_soh.LOC IN ('62')
ORDER BY item_loc_soh.ITEM, item_master.ITEM_DESC;
Telegram: DB developers channel