1 AUTOMATIC 0 0 0 0 0 0 http://xmlns.oracle.com/ku 1.0 MATERIALIZED_VIEW MATERIALIZED VIEW MATERIALIZED VIEW USING_NO_INDEX PARSE SQL PARSE SQL FOR_UPDATE SUBQUERY PARSE SQL RANGE-LIST RANGE LIST HASH NAME NOT_ALTERABLE MV_INDEX_ORGANIZATION -- can not alter Materialized view index organization PARSE SQL NAME CLAUSE_TYPE PHYSICAL_ATTRIBUTES ALTER MATERIALIZED VIEW NAME NOT_ALTERABLE USING_NO_INDEX FOR UPDATE SUBQUERY -- can not alter USING_NO_INDEX -- can not alter FOR UPDATE -- can not alter SUBQUERY NAME NOT_ALTERABLE cannot ADD,DROP between RANGE,LIST,HASH -- cannot ADD,DROP between RANGE,LIST,HASH NAME CLAUSE_TYPE USING_INDEX NOT_ALTERABLE PCTFREE NOT_ALTERABLE PCTUSED -- can not alter USING INDEX PCTFREE or PCTUSE ALTER MATERIALIZED VIEW USING INDEX INITRANS TABLESPACE NAME CLAUSE_TYPE MODIFY_MV_REFRESH NOT_ALTERABLE UNDO REFRESH/START_WITH (DATE) NOT_ALTERABLE UNDO REFRESH NEXT (DATE) NOT_ALTERABLE UNDO REFRESH WITH PRIMARY KEY NOT_ALTERABLE UNDO REFRESH FAST NOT_ALTERABLE UNDO REFRESH FORCE NOT_ALTERABLE UNDO REFRESH COMPLETE NOT_ALTERABLE REFRESH WITH ROWID NOT_ALTERABLE UNDO REFRESH ON COMMIT NOT_ALTERABLE UNDO REFRESH ON COMMIT NOT_ALTERABLE LOCAL_ROLLBACK_SEGMENT ALTER MATERIALIZED VIEW REFRESH COMPLETE ON COMMIT FAST WITH PRIMARY KEY START WITH NEXT USING MASTER ROLLBACK SEGMENT USING DEFAULT MASTER ROLLBACK SEGMENT USING CONSTRAINTS NAME CLAUSE_TYPE QUERY_REWRITE ALTER MATERIALIZED VIEW DISABLE QUERY REWRITE ENABLE QUERY REWRITE PARSE SQL