Home » Server Options » Replication » Replication from 10.2.0.4 to 9.2.0.6 (10.2.0.4, 9.2.0.6)
Replication from 10.2.0.4 to 9.2.0.6 [message #431783] Thu, 19 November 2009 08:06 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
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
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 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: (materialized view) Replication Oracle - MS SQL Server
Next Topic: materialized view replication
Goto Forum:
  


Current Time: Thu Mar 28 12:35:53 CDT 2024