Re: Materialized Views
From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 12 Jan 2010 22:24:00 +0100
Message-ID: <4B4CE870.6020809_at_gmail.com>
On 12.01.2010 20:42, The Magnet 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;
Date: Tue, 12 Jan 2010 22:24:00 +0100
Message-ID: <4B4CE870.6020809_at_gmail.com>
On 12.01.2010 20:42, The Magnet 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;
According to Note ID 301627.1 on commit with master tables on remote database is not supported. Maybe in newer releases things have changed, but on 10.2.0.4 it still seems to be the no way around.
Best regards
Maxim Received on Tue Jan 12 2010 - 15:24:00 CST