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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l