1 1 1 1 0 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 MATERIALIZED VIEW STORE AS SECUREFILE BASICFILE ( TABLESPACE " " ENABLE STORAGE IN ROW CHUNK PCTVERSION NOCACHE CACHE ASYNC SYNC 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