I have no prevoius experience with oracle. We have Oracle Entertprise
Edition 8.0.4 for windows NT 4.0. I have to replicate some tables from
server 1 to rempte server 2. Server 2 has the same OS and same version
of Oracle. I want to use asynchronous multimaster replication.
Since I am in a learning stage now, I don't want to craete a new
database. I want to add some new tables to the schema scott and try to
replicate that.
1)Is that a wise step? Do I have to grant dba permission to scott for
that?
2) If I use replication manager, do I have to create the database links
using SQl*Plus or rep. manager will do that for me? Also do I have to
create the schema in the remote server that will contain the replicated
objects prior to using rep. manager? Also is there anything to change in
the init.ora file?
3)What is the role of propagator, receiver, replication admin ? Is there
any problem if they are different users?
4)Is there any way to replicate from Oracle to Access?
6) Can anyone suggest a good book that talk about in details about
multimaster replication? I have the online manuals that came with the CD
and lots of things are not clear to me?
I will be more than happy if someone takes some time to answer these
questions.
-Nimat
Received on Fri Aug 07 1998 - 13:35:40 CDT
