OraFAQ Forum: Replication » Replication from 10.2.0.4 to 9.2.0.6

Home » Server Options » Replication » Replication from 10.2.0.4 to 9.2.0.6 (10.2.0.4, 9.2.0.6)

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

Replication from 10.2.0.4 to 9.2.0.6 [message #431783]

Thu, 19 November 2009 08:06

shiva_jm
Messages: 9
Registered: November 2009

Junior Member

Are there any recommendations to replicate oracle tables from 10.2.0.4 to 9.2.0.6 ?

I am new to oracle, thinking about streams and material views. And not sure which option should we choose ?

Any pros and cons (especially related to the versions). Can I use streams to replicate 10.2.0.4 to 9.2.0.6 ?

Thank you
Siva

Report message to a moderator

Re: Replication from 10.2.0.4 to 9.2.0.6 [message #431787 is a reply to message #431783]

Thu, 19 November 2009 08:17

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes with some limitations. You can't use 10gR2 features or types that do not exist or are not supported in 9.2...

Regards
Michel

Report message to a moderator

Re: Replication from 10.2.0.4 to 9.2.0.6 [message #431852 is a reply to message #431787]

Thu, 19 November 2009 12:24

shiva_jm
Messages: 9
Registered: November 2009

Junior Member

Thank you Michael,

Do you mean limitations related to data types ?

Any documentation on guidence on implementing streams ?

Thank you
Siva

Report message to a moderator

Re: Replication from 10.2.0.4 to 9.2.0.6 [message #431865 is a reply to message #431852]

Thu, 19 November 2009 12:55

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

http://tahiti.oracle.com contains a book on Streams for each of your versions. I'm afraid you have to read them both in order to know what you can do.

Regards
Michel

Report message to a moderator

Previous Topic:	(materialized view) Replication Oracle - MS SQL Server
Next Topic:	materialized view replication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 24 07:44:10 CST 2026