Hi Friends, I am getting an error when creating a materialized view: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view The schema has the following sys privs. CREATE MATERIALIZED VIEW ON COMMIT REFRESH DROP ANY DIRECTORY CREATE SESSION DELETE ANY TABLE QUERY REWRITE CREATE DATABASE LINK CREATE SEQUENCE DROP ANY TABLE CREATE ANY TABLE DROP USER CREATE TYPE CREATE ANY DIRECTORY ALTER USER CREATE USER UNLIMITED TABLESPACE DROP PUBLIC SYNONYM CREATE PUBLIC SYNONYM CREATE TABLE CREATE TRIGGER SELECT ANY TABLE CREATE PROCEDURE CREATE SYNONYM ALTER SESSION CREATE INDEXTYPE ANALYZE ANY CREATE VIEW I created the materialized view log as: create materialized view log on CH_TRACT_F with rowid; CREATE MATERIALIZED VIEW VW_ALL_SOIL_F BUILD IMMEDIATE refresh fast on commit with rowid AS SELECT CH_TRACT_F.ID , rowid AS ROW_ID , 'allSoil' , CH_TRACT_F.SHOW_SUBFEATURE , CH_TRACT_F.SCALE_FACTOR , CH_TRACT_F.TEXT , CH_TRACT_F.GEOMETRY , CH_TRACT_F.ROTATION , CH_TRACT_F.ANCHOR_X , CH_TRACT_F.ANCHOR_Y , CH_TRACT_F.CH_TRACT_ID FROM CH_TRACT_F WHERE CH_TRACT_F.FEATURE_TYPE = 'Soil'; What is wrong: Regards Eriovaldo -- //www.freelists.org/webpage/oracle-l