Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to do the replication?
Hi,
If you use simple replication (master-site and snapshots) on the snapshot-site
there are no tables as they are
at the master site and they may not be there before setting up replication. The
data is the the snapshot and you get
a view named like the table on the master site. And yes they are for reading
primarily. But if you have the Enterprise-Edition
for the master-site you can build updateable snapshots if the query is simple.
If you want tables on both sites you need
advanced (multi-master) replication with Enterprise-Edition on both sites.
I hope this helps to understand the mechanisms for replication.
Helmut Received on Thu Sep 16 1999 - 01:36:29 CDT
![]() |
![]() |