Home » Server Options » Replication » Single Master Replication
Single Master Replication [message #289736] Tue, 25 December 2007 23:24 Go to next message
Messages: 8
Registered: December 2007
Junior Member
Hi ,

Is it possible to create replication on same database with different schema ?

Thanks in advance
Re: Single Master Replication [message #289738 is a reply to message #289736] Tue, 25 December 2007 23:37 Go to previous message
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Why not ..possible in many ways .. if you want to setup replication using the materialized views concept . then create a public synonym for the object you want to replicate and then create the materialized view in the schema where you want the object to be replicated.

create materialized view samplerep
refresh complete on demand
select col1, col2, col3 from A.table1;

-Sai Jeedigunta
Previous Topic: Help in Replication, step to create updateble M.V.
Next Topic: Pls Help
Goto Forum:

Current Time: Sun Nov 28 00:15:40 CST 2021