Materialized View Replication
- From: Björn Wächter <bwc@xxxxxxxxxxxxxxx>
- Date: Fri, 27 Jan 2006 15:50:55 +0100
Hello all,
I want to use this in an Oracle 10g enviroment between
two databases.
CONNECT scott/tiger@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@xxxxxxxxxx;
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
.
- Follow-Ups:
- Re: Materialized View Replication
- From: DA Morgan
- Re: Materialized View Replication
- Prev by Date: How to Compare Two Records?
- Next by Date: Re: pivot/transform in Oracle
- Previous by thread: How to Compare Two Records?
- Next by thread: Re: Materialized View Replication
- Index(es):