210.238.239.36:43499
ils_nagaishi
Adm_create


BIZ10H/BIZ10H@ILS-CL102

SET AUTOTRACE ON;
SET AUTOTRACE TRACEONLY;
SET TIMING ON;
SET LINESIZE 120;


ALTER SYSTEM FLUSH SHARED_POOL;
ALTER SYSTEM FLUSH BUFFER_CACHE;

CREATE INDEX BIZ10H.IDX_WVIEW0011_YYYYMM_7
ON BIZ10H.WVIEW0011_YYYYMM
(VPERIOD, VKEY7)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE BIZ10H
STORAGE(INITIAL 64K NEXT 1M MINEXTENTS 1 MAXEXTENTS 2147483645 BUFFER_POOL DEFAULT)
NOLOGGING
VISIBLE
/