Home » Server Options » Replication » Single Master Replication
Single Master Replication [message #289736] Tue, 25 December 2007 23:24 Go to next message
arthik_babu
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
vjeedigunta
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.

Ex:
create materialized view samplerep
refresh complete on demand
as
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: Thu Mar 28 13:51:08 CDT 2024