Well, I wouldn't place space issues in priority of failback. Btw, you can upgrade to 10.1 and then downgrade it back to any patchset of 9.2 (don't remeber about others). I tried it on our test system and it worked fine. I ran some production traffic before/after upgrade/downgrade and didn't see any issues. Of course, it doesn't mean there would be no problem in your case. On Wed, 16 Feb 2005 17:01:29 -0000, Barr, Stephen <Stephen.Barr@xxxxxxxxx> wrote: > Unfortunately due to space limitations, we cannot just copy the files. > > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Mercadante, Thomas F > Sent: 16 February 2005 16:40 > To: 'Stephen.Barr@xxxxxxxxx'; oracle-l@xxxxxxxxxxxxx > Subject: RE: 9.2.0.5.0 to 10g AND BACK! > > Steve, > > Well, if you transport them, they can still exist in the 9.2 database, > right? Can't you just copy the files into the 10G directory and import the > schema? > > Tom > > -----Original Message----- > From: Barr, Stephen [mailto:Stephen.Barr@xxxxxxxxx] > Sent: Wednesday, February 16, 2005 11:21 AM > To: oracle-l@xxxxxxxxxxxxx > Subject: 9.2.0.5.0 to 10g AND BACK! > > We're looking to transport our tablespaces from 9.2.0.5.0 to a 10g DB for > testing (not a production box). > However, it would be nice to transport the tablespaces back again to > 9.2.0.5.0 if things don't work out as expected! > > Is this possible or is it one-way only? > > Many thanks, > > Steve. > > ----------------------------------------------------------------------- > Information in this email may be privileged, confidential and is > intended exclusively for the addressee. The views expressed may > not be official policy, but the personal views of the originator. > If you have received it in error, please notify the sender by return > e-mail and delete it from your system. You should not reproduce, > distribute, store, retransmit, use or disclose its contents to anyone. > > Please note we reserve the right to monitor all e-mail > communication through our internal and external networks. > ----------------------------------------------------------------------- > > -- > //www.freelists.org/webpage/oracle-l > -- > //www.freelists.org/webpage/oracle-l > > . > -- > //www.freelists.org/webpage/oracle-l > -- Best regards, Alex Gorbachev -- //www.freelists.org/webpage/oracle-l