SQL & PL/SQL

Hello All,

I'm trying change the settings on a materialized view I have. I would like it to fast refresh refresh everytime there is an commit on one of 2 tables.
But I keep getting the error ORA-12054. I've checked the conditions under which this happens, and I'm not using any raw, sub-selects etc.

Thanks for any assistance or pointers

Jan

Here is the DML generated by SQL Developer.

CREATE MATERIALIZED VIEW "JSNOTIONS"."MVW_EMP_CONTACTS2" ("SEQ", "ID", "FIRST_NAME", "LAST_NAME", "CUST_ID") ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS BASIC LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "JSNOTIONS" BUILD IMMEDIATE USING INDEX REFRESH FORCE ON DEMAND USING DEFAULT LOCAL ROLLBACK SEGMENT USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE
AS
  SELECT rownum seq ,
    employee_id AS id,
    first_name,
    last_name,
    cust_id
  FROM ori_employees
  UNION ALL
  SELECT rownum seq ,
    contact_id AS id,
    first_name,
    last_name,
    cust_id
  FROM ori_contacts;