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_at_bskyb.com> wrote:
> Unfortunately due to space limitations, we cannot just copy the files.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Mercadante, Thomas F
> Sent: 16 February 2005 16:40
> To: 'Stephen.Barr_at_bskyb.com'; oracle-l_at_freelists.org
> 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_at_bskyb.com]
> Sent: Wednesday, February 16, 2005 11:21 AM
> To: oracle-l_at_freelists.org
> 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.
> -----------------------------------------------------------------------
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>
> .
> --
> http://www.freelists.org/webpage/oracle-l
>
--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 16 2005 - 16:14:59 CST
