RE: Transportable tablespaces and Oracle downgrading...

  • From: "Grabowy, Chris" <chris.grabowy@xxxxxxxx>
  • To: "Ian Cary (C)" <Ian.Cary@xxxxxxxxxxxxxxxxxxxx>, mrothouse@xxxxxxxxx, David Sharples <davidsharples@xxxxxxxxx>
  • Date: Fri, 02 Jun 2006 12:47:50 -0400

So it would appear that the two base compatibilities in this situation
are 10.0 and 10.2.  
 
And it would appear that the base capability is the version AND release
of the Oracle database.
 
Thank you Ian for testing this.  Greatly appreciated.  We can now focus
our efforts on exp/imp or perhaps take another shot at datapump.
 
Thanks everyone.

  _____  

From: Ian Cary (C) [mailto:Ian.Cary@xxxxxxxxxxxxxxxxxxxx] 
Sent: Friday, June 02, 2006 9:06 AM
To: mrothouse@xxxxxxxxx; David Sharples
Cc: oracle-l@xxxxxxxxxxxxx; Grabowy, Chris
Subject: RE: Transportable tablespaces and Oracle downgrading...



I thought I'd give this a test for you - trying to TTS from 10.2 to
10.1.0.4 and got

 

IMP-00003: ORACLE error 721 encountered

ORA-00721: changes by release 10.2.0.0.0 cannot be used by release
10.0.0.0.0

ORA-06512: at "SYS.DBMS_PLUGTS", line 2025

 

I must admit I'm a little puzzled by the '10.0.0.0.0' as the
compatibility for my 10.1.0.4 is set to 10.1.0 but I can't say I'm
overly surprised by the result

 

Cheers,

 

Ian

 

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mike Rothouse
Sent: 01 June 2006 18:52
To: David Sharples
Cc: oracle-l@xxxxxxxxxxxxx; chris.grabowy@xxxxxxxx
Subject: Re: Transportable tablespaces and Oracle downgrading...

 

Same or higher after computing the minimum compatibility level which in
his case is 10.0.  He's not going from 10g to 9i.

On 6/1/06, David Sharples < davidsharples@xxxxxxxxx> wrote:

I read that as same or higher, this guy wants to go lower 

 

On 01/06/06, Mike Rothouse <mrothouse@xxxxxxxxx > wrote: 

If I understand the manual correctly, going from 10gR2 to 10gR1 should
be okay with TTS.

 

.


This email is only intended for the person to whom it is addressed and
may contain confidential information. If you have received this email in
error, please notify the sender and delete this email which must not be
copied, distributed or disclosed to any other person.

Unless stated otherwise, the contents of this email are personal to the
writer and do not represent the official view of Ordnance Survey. Nor
can any contract be formed on Ordnance Survey's behalf via email. We
reserve the right to monitor emails and attachments without prior
notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

Other related posts: