Implemetation of replication (very urgent please)

[ravisanapala]

How to implement replication between two databases.I am using oracle 8.1.5 with NT4.0.Pls give some suggetions on t this .

[oddster]

a one off , or continuous replication?

You need to provide more infromation

[TimHall]

Hi.

That's a very big question. I would be careful about jumping in feet first before you really understand the implications. I'm assuming you mean advanced replication.

You can use OEM to set up replication. If you prefer the traditional command line route give these a go:

http://www.orafaq.com/faqrepl.htm
http://www.orafaq.com/faqscrpt.htm#ADVREP

That should get you started.

If you are looking for simple replication check out materialized views (snapshots) where the query uses a database link to your master site.

Good luck!

Tim...

[pando]

advanced replication is not just set up and that's it ok, you have to create pl/sql procedures & packages for your conflict resolution and if you want to do it good you have to create auditing tables as well to capture the conflicts

[ravisanapala]

I want continuous replication

[pando]

you want syncronous replication but that doesnt say which type of replication you want, basic or advanced. Read Oracle docu about the difference and if you have further queries come back

[ravisanapala]

I am using the replication proceudre which is given in the oracle doc