Error when creating materialized view

  • From: Eriovaldo Andrietta <ecandrietta@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 3 May 2012 21:00:44 -0300

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


Other related posts: