iam using Oracle9.2
i tried with setting query_rewrite_enables=false
now it shows error as

ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view