Fast refresh on Materialized view [message #5440] |
Mon, 17 February 2003 05:28 |
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
|
|
|
|