Re: Oracle streams between 9i and 10g

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Mon, 06 Oct 2008 15:06:37 +0200

I am aware of the difference between 9 and 10.
We plan to do the move twice.
One full move and then test the application, including stress test with load runner. After we get the OK we clean the new database and do the copy again, this time as production.

I am asking about the feasibility of using streams from RAC 9.2 on windows to RAC 10.2 on Linux for the copy, and the other way to keep the old database in sync, after we move to production, in case we need to fall back.

Adar Yechiel
Rechovot, Israel

Bort, Guillermo wrote:
I'd go with Export/Import and statistics recollection for the tables
migrated. Also, be advised that moving from 9i to 10g is not always
simple, and usually execution plans change. So I'd say quiet a lot of
testing should be done before moving the production environment.

Remember, 10G does not have RBO.


Guillermo Alan Bort
EDS - ITO DBA Main Group

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yechiel Adar
Sent: Sunday, October 05, 2008 12:54 PM
Subject: Oracle streams between 9i and 10g

I have a 9.2 database on windows, rac, and we want to move it to Linux.
I have a Linux rac, ready.

Can I use streams for this?

Is it possible, in a simple way, to stream also from Linux 10.2 to 9.2 so we can fall back without problems?

Any experience?


Other related posts: