Re: Refresh fast on commit not working for my MV

From: Lucyna Witkowska <ypwitkow_at_nospamcyf-kr.edu.pl>
Date: Tue, 8 Jul 2003 09:23:02 +0000 (UTC)
Message-ID: <bee2hm$454$1@srv.cyf-kr.edu.pl>

JamesLane <JamesLane03_at_yahoo.com> wrote:

> I have built a Materialized View on a separate database than the
> tables it uses successfully. When I changed the refresh method from
> on demand to on commit, I receive an error message saying "ORA-12054:
> cannot set the ON COMMIT refresh attribute for the materialized view"

You cannot build Materialized View refreshed ON COMMIT with remote tables. ON COMMIT works with local tables only :-(

Regards,
LW Received on Tue Jul 08 2003 - 04:23:02 CDT