Problem with Materialized View

Hi,

I'm having a problem using a materialized view here.

I'm using this table:

> CREATE TABLE MOTOR (
> VMOT_ID NUMBER(32) NOT NULL,
> VMOT_ENTW_DATUM DATE NOT NULL,
> BEMERKUNG VARCHAR2(2000)
> CONSTRAINT PK_MOTOR
> PRIMARY KEY ( VMOT_ID, VMOT_ENTW_DATUM )
> USING INDEX PCTFREE 10
> TABLESPACE TEIM_IDX)
> TABLESPACE TEIM_TAB PCTFREE 10;
>
>
> create materialized view log on MOTOR
> tablespace teim_tab
> storage (initial 10k next 10k pctincrease 0)
> with rowid, primary key;
>
>
> create materialized view TEST
> refresh fast on commit with rowid
> as select
> VM.ROWID VMOT_ROWID,
> VM.VMOT_ID,
> VM.VMOT_ENTW_DATUM
> FROM VERBRENNUNGSMOTOR VM;
>

Then SQL*Plus gives me:

> FROM MOTOR VM
> *
> ERROR at line 7:
> ORA-12051: ON COMMIT attribute is incompatible with other options
>

Any idea what's going wrong? Why is the ON COMMIT attribute not allowed here? Received on Thu Apr 27 2000 - 03:13:00 CDT