Re: remote date transfer

Hmm, can't see the original post so I don't know what the original question was. Replication Manager is a GUI front end to all the stored procedures and packages used with replication. From memory it comes on the Enterprise Manager CD.

To enable replication you need to be running Enterprise Edition and install the replication option. This will run catrep and a few more scripts to enable it. Depending on your version, it was a separately purchasable option (that may not be the case in 8i, but I never have to pay for it anyway!).

Connection from one database to another needs a database link (or multiple links in the case of replication) to be set up. Check the SQL Reference manual for how to set up a database link.

HTH. Pete

narayan wrote:

> hi pete,
> thing is that the replication is to be done usingf stored procedures.
> but frankly i have no idea about what replication manager is.
> and how to enable the replication option.
> we are using oracle 8 servers on windows nt platform.
> and at both the servers the sid is the same -orcl.
> and when we tried to connect from on database to another
> we couldn't do so.
> hey
> wish u grand and prosperous millenium.
> thanks.
> narayan
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

Received on Thu Dec 30 1999 - 11:22:11 CST