Error when creating materialized view
Date: Thu, 3 May 2012 21:00:44 -0300
Message-ID: <CAJdDhaM0rP4RS4XwM4t2PFBY6Dz9xyhJ2rg9o3ebqLdnW6X8dw_at_mail.gmail.com>
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-lReceived on Thu May 03 2012 - 19:00:44 CDT