We are getting the following error
select * from weight_slip@park union select * from weight_slip@ang;
Park wrote:Did you modify the query to add the UNION ALL marker that the documentation I linked to discussed?
Do you need to UNION the results together? Or could you do a UNION ALL instead? If you modified your query to add a UNION ALL marker, it should be possible to create a fast-refreshable materialized view.
We have Tried using UNION ALL But the error persists .We thought it might me due to connection to different db links.
>There are advantages and disadvantages to having separate materialized views. If one of the remote databases is unavailable, for example, you'd still be able to refresh the other materialized view. That may be advantageous or it may be disadvantageous to you depending on what you would want to happen if only one of the two sets of data were refreshed.
Could you replicate the data from each site separately with a WEIGHT_SLIP_PARK and a WEIGHT_SHIP_ANG materialized view and then combine the data locally (via a UNION or a UNION ALL)?
This solution looks good.Does it hold and an advantage in terms of reliability and are you suggesting we create a materialized view of materialized view (WEIGHT_SLIP_PARK and a WEIGHT_SHIP_ANG tables) with UNION at the central server for automatic synchronization.
SELECT 1 AS marker,SNO,WEIGHT from weight_slip@park UNION ALL SELECT 2 AS marker,SNO,WEIGHT from weight_slip@ang;
If i try it with query rewrite enabled it says
ORA-12052: cannot fast refresh materialized view weight_slip
Failed to commit: ORA-30353: expression not supported for query rewrite