Hi Eriovaldo, I'm glad that my tip helped you solve the issue. Best Regards, Rodrigo Mufalani Oracle Ace Member Tel.: +55 21 88994817 http://www.mufalani.com.br <img src=http://mufalani.com.br/site/wp-content/uploads/2012/01/logo.png /img> Rodrigo, I take out the column with SDO_GEOMETRY and it worked fine. Thanks and Best Regards Eriovaldo On Thu, May 3, 2012 at 11:05 PM, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>wrote: > Rodrigo, > > Here are data_types extracted from user_tab_columns: > > NUMBER > VARCHAR2 > SDO_GEOMETRY <<<<< THIS IS DIFFERENT >>>>>>>>>> > NUMBER > NUMBER > NUMBER > NUMBER > NUMBER > VARCHAR2 > NUMBER > > > Att > Eriovaldo > > On Thu, May 3, 2012 at 9:09 PM, Rodrigo Mufalani > <rodrigo@xxxxxxxxxxxxxxx>wrote: > >> Hi, >> >> Do the base table has any special kind of datatype?! >> >> Best regards, >> Mufalani >> >> Enviado via iPhone >> >> Em 03/05/2012, às 21:00, Eriovaldo Andrietta <ecandrietta@xxxxxxxxx> >> escreveu: >> >> > 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 >> > >> > >> > > -- //www.freelists.org/webpage/oracle-l