Materialized View Problem

[RAFF]

Hi !
I want to ask the same question again . I havent got any positive feedback from here, may be i was not able to describe my problem.
Any way , all i want is to create a materializsed view with the DEFERRED option. This matreialized view is based on an remote table, so i have to access it through database link. The other important thing is the remote table contains a column of LOB datatype. This causes my materialized view statement to failed.
IF I replace the BUILD DEFERRED keyword with BUILD IMMEDIATE, it works fine, but i dont want to do that, have to use the DEFERRED option.
Suggesstions???
RAFF

[julian]

Hi, do the following (this is how I have implemented it):

create materialized view PICTURES
PCTFREE 10 PCTUSED 40 MAXTRANS 255
STORAGE (INITIAL 1024K NEXT 1024K MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
TABLESPACE NOKIA_01_DATA_MED
BUILD IMMEDIATE
USING INDEX TABLESPACE NOKIA_01_INDEX_MED
PCTFREE 10 INITRANS 2 MAXTRANS 255
STORAGE(INITIAL 256K NEXT 256K PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 2147483645
FREELISTS 1 FREELIST GROUPS 1)
REFRESH fast WITH PRIMARY KEY
START WITH trunc(sysdate) + 5/24
NEXT trunc(sysdate+1) + 5/24
AS
SELECT * FROM DB_REMOTE.PICTURES@DB_LINK_NAME;

ALTER TABLE PICTURES
ADD(CONSTRAINT PICTURES_NULL CHECK(DATA_LOB IS NOT NULL)
INITIALLY DEFERRED)
MODIFY(DATA NULL);