Re: Error when creating materialized view

  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_at_gmail.com>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_at_mufalani.com.br>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_at_gmail.com>
>> 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
>> >
>> >
>> > --
>> > http://www.freelists.org/webpage/oracle-l
>> >
>> >
>>
>
>

--
http://www.freelists.org/webpage/oracle-l