Re: Materialized Views

An MV across a DBLink *cannot* be an ON-COMMIT MV.

See my explanation at http://hemantoracledba.blogspot.com/2008/06/mvs-with-refresh-on-commit-cannot-be.html

Hemant K Chitale

On Jan 13, 3:42 am, The Magnet <a..._at_unsu.com> wrote:
> I'm getting an error when I try an do a fast refresh on a materialized
> view.  The base table is very simple, 3 columns.  But, it exists over
> a database link.  Like everyone else I am receiving a ORA-12054.  I've
> had no luck with tryong everything out with all the example
> definitions.  This is one table with a primary key, I do not know what
> could be more simple.  I've pasted my definitions below.
>
> BTW:  I tried both INCLUDING and EXCLUDING on the log:
>
> CREATE MATERIALIZED VIEW LOG ON WIDGET.WIDGETS
> WITH PRIMARY KEY
> INCLUDING NEW VALUES;
>
> CREATE MATERIALIZED VIEW WIDGET.WIDGETS
> REFRESH FAST ON COMMIT
> AS
> SELECT ROWID,
>    "WIDGET_ID",
>    "WIDGET_NAME",
>    "WIDGET_OPTIONS"
> FROM "WIDGETS"_at_NIVA.COM;
Received on Tue Jan 19 2010 - 08:28:26 CST