Materialized View Replication

From: Björn Wächter <bwc_at_p3-solutions.de>
Date: Fri, 27 Jan 2006 15:50:55 +0100
Message-ID: <43uqagF1po1erU1@news.dfncis.de>

Hello all,

I want to use this in an Oracle 10g enviroment between two databases.

CONNECT scott/tiger_at_tsh2

CREATE DATABASE LINK TSH1.WORLD CONNECT TO scott IDENTIFIED BY tiger USING 'TSH1.WORLD'; CREATE MATERIALIZED VIEW emp_mv
BUILD IMMEDIATE
REFRESH FORCE
ON DEMAND
AS
SELECT * FROM emp_at_tsh1.world;

The problem is that I'm not able to create the db link from tsh2 to tsh1 but it is possible to create it from tsh1 to tsh2. Is there a way to use replication?

Thanks Björn Received on Fri Jan 27 2006 - 08:50:55 CST