Re: Materialized View Replication

Björn Wächter wrote:
> 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

Make sure tsh2 has tsh1 in its TNSNAMES.ORA file.

What error message are you getting? The actual message not your interpretation of it.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)