CREATE MATERIALIZED VIEW MV_POS_FT_SALES04
PARTITION BY RANGE ("CD_YMD_DATE") INTERVAL (NUMTOYMINTERVAL(1,'MONTH')) STORE IN ("BISDATA")
(PARTITION "P1" VALUES LESS THAN (TO_DATE(' 2016-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS NOLOGGING
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BISDATA" ,
PARTITION "P2" VALUES LESS THAN (TO_DATE(' 2016-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
NOCOMPRESS NOLOGGING
STORAGE(
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "BISDATA" )
PARALLEL 4 ENABLE ROW MOVEMENT
TABLESPACE "BISDATA"
BUILD IMMEDIATE
REFRESH FORCE ON DEMAND
AS
위와 같이 MATERIALIZED VIEW 작성하였는데 테이블에 데이터가 1억건이 넘어서 40분이 넘어도 mv생성이 안되네요 ㅠㅠ
혹시 mv생성시 추가적으로 옵션 줄 수 있는게 더 있을지 문의드립니다 ^^