Home » Server Options » Replication » Fast refresh on Materialized view
Fast refresh on Materialized view [message #5440] Mon, 17 February 2003 05:28 Go to next message
Kavitha
Messages: 40
Registered: December 1999
Member
Hi,

I am creating a materialized view which joins more than one remote table. I need to make this a fast refresh.

If I issue the following select, then I am able to do a fast refresh, as they are equi join:

SELECT
app.application_id,
app.rowid,
pro.product_id,
pro.rowid,
hol.hol_id,
hol.rowid
FROM ano_user.pro,
ano_user.app,
ano_user.hol
WHERE app.product_id = pro.product_id
AND app.application_id = hol.application_id

But if I specify the Database link for these tables, then I fast refresh is not possible because "mv references a remote table or view in the FROM list"

SELECT
app.application_id,
app.rowid,
pro.product_id,
pro.rowid,
hol.hol_id,
hol.rowid
FROM ano_user.pro@source_db_link,
ano_user.app@source_db_link,
ano_user.hol@source_db_link
WHERE app.product_id = pro.product_id
AND app.application_id = hol.application_id

Does anybody know how to get over this problem? I am using DBMS_MVIEW package to check the MV capabilities.

Cheers
Kavitha
Re: Fast refresh on Materialized view [message #5482 is a reply to message #5440] Tue, 18 February 2003 09:14 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
if U use @ it's not MV anymore .. it's SNAPSHOT ...
Previous Topic: Can replication be used to append to a materialized view instead of refresh
Next Topic: Oracle 8i Synchronization
Goto Forum:
  


Current Time: Thu Mar 28 14:21:22 CDT 2024