1 1 1 1 0 CREATE MATERIALIZED VIEW OF ( " " , ) ON PREBUILT TABLE WITH WITHOUT REDUCED PRECISION LOB ( ) CACHE USING NO INDEX USING INDEX NEVER REFRESH FOR UPDATE ENABLE QUERY REWRITE DISABLE QUERY REWRITE AS AS 0 STORE AS SECUREFILE BASICFILE ( TABLESPACE " " ENABLE STORAGE IN ROW CHUNK PCTVERSION NOCACHE CACHE ENCRYPT DECRYPT COMPRESS HIGH COMPRESS MEDIUM COMPRESS LOW NOCOMPRESS DEDUPLICATE OBJECT DEDUPLICATE LOB KEEP_DUPLICATES VALIDATE ) BUILD REFRESH FAST COMPLETE FORCE ON COMMIT ON DEMAND WITH ROWID WITH PRIMARY KEY START WITH NEXT USING DEFAULT MASTER LOCAL ROLLBACK SEGMENT USING CONSTRAINTS