Home » Server Options » Replication » Doubt in Replicating Data from DB to another (Oracle 10g)
Doubt in Replicating Data from DB to another [message #452109] Tue, 20 April 2010 02:00 Go to next message
kunalkumar2611
Messages: 4
Registered: April 2010
Junior Member
Hi All,

I have situation where i need to copy data from certain table's from one DB to another at random intervals. Table structure for the one's getting copied can be same in both the DB.

After reading various posts here i have understood that it can be done using Oracle Replication and Oracle stream.

I need someone to help me in simple language how these 2 methods work and how they are different from each other.

And is there any other way to copy data between DB's apart from the one's i have understood.

Thanks in advance
Re: Doubt in Replicating Data from DB to another [message #452113 is a reply to message #452109] Tue, 20 April 2010 02:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What about first reading the documentation?

Regards
Michel
Re: Doubt in Replicating Data from DB to another [message #452283 is a reply to message #452113] Wed, 21 April 2010 01:43 Go to previous messageGo to next message
kunalkumar2611
Messages: 4
Registered: April 2010
Junior Member
yeah i have gone through the documentation. but as far as i can understand they require dblinks to be used.

What i want to know is that whether this kind of replication work be done without using dblinks.
Re: Doubt in Replicating Data from DB to another [message #452287 is a reply to message #452283] Wed, 21 April 2010 02:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Logical standby.

Regards
Michel
Re: Doubt in Replicating Data from DB to another [message #460370 is a reply to message #452287] Thu, 10 June 2010 15:10 Go to previous message
sovekconsulting
Messages: 9
Registered: June 2010
Location: Canada
Junior Member
please try our database replication product -
www.sovek-consulting.com/index.php/products/data-replication
Previous Topic: Replication in 10G without DB links.
Next Topic: ORA-12034 Error
Goto Forum:
  


Current Time: Thu Mar 28 09:56:11 CDT 2024