OraFAQ Forum: Replication » Doubt in Replicating Data from DB to another

Home » Server Options » Replication » Doubt in Replicating Data from DB to another (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Doubt in Replicating Data from DB to another [message #452109]

Tue, 20 April 2010 02:00

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

Report message to a moderator

Re: Doubt in Replicating Data from DB to another [message #452113 is a reply to message #452109]

Tue, 20 April 2010 02:15

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What about first reading the documentation?

Regards
Michel

Report message to a moderator

Re: Doubt in Replicating Data from DB to another [message #452283 is a reply to message #452113]

Wed, 21 April 2010 01:43

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.

Report message to a moderator