Re: Oracle streams between 9i and 10g

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • Date: Tue, 07 Oct 2008 08:06:00 +0200

Thanks Joel.
I read you document and it was just what the doctor ordered.

I will post my experience later.

Adar Yechiel
Rechovot, Israel

Joel.Patterson@xxxxxxxxxxx wrote:
I have attached an interesting concept "Upgrading Oracle 9i database to
oracle 10g database with near-Zero downtime" -- Using Streams.  Not sure
if you are interested, but thought I put it out there.   Chances are
that there will be one or more things present that will prevent you from
succeeding such as 'Long datatypes' that have not been converted to
CLOBs yet.   (just and example).

Surely it works for his example... but I have not had the chance to make
it work for a 'real' database.

Joel Patterson
Database Administrator
904  727-2546

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Yechiel Adar
Sent: Monday, October 06, 2008 9:07 AM
Subject: Re: Oracle streams between 9i and 10g

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
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: