MV problem with OR condition on Oracle 8.1.7

From: Jw <jor_wei_at_hotmail.com>
Date: 31 Mar 2002 16:48:55 -0800
Message-ID: <3d4e5e40.0203311648.3a578ad3@posting.google.com>

I try to create MV with OR condition on Oracle 8.1.7 but with below error message. But the same MV was successfully created under Oracle 8.1.6. Anybody has any answer for this.

CREATE MATERIALIZED VIEW SAMPLE.MV_TESTING PARALLEL BUILD IMMEDIATE
REFRESH FAST ON COMMIT
WITH ROWID
AS
SELECT ROWID "A_RID", COMPANY_ID, COMPANY_NAME, UPPER(COMPANY_NAME) AS COMP_NAME_UPPER
FROM
SAMPLE.COMPANY_PROFILE
WHERE
COMPANY_TYPE = 'B' OR COMPANY_TYPE = 'A' ERROR at line 9:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

Thanks
Joe Received on Sun Mar 31 2002 - 18:48:55 CST