RE: Oracle streams between 9i and 10g
Date: Mon, 6 Oct 2008 07:59:17 -0500
Message-ID: <785A4E1EF4D9E745BAC909B7941BEC0094F517@usplm201.amer.corp.eds.com>
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.
HTH.
Guillermo Alan Bort
EDS - ITO DBA Main Group
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar
Sent: Sunday, October 05, 2008 12:54 PM
To: ORACLE-L
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, 10.2.0.3 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?
--
Adar Yechiel
Rechovot, Israel
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 06 2008 - 07:59:17 CDT