RE: Transportable tablespaces and Oracle downgrading...

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_at_ordnancesurvey.co.uk] Sent: Friday, June 02, 2006 9:06 AM
To: mrothouse_at_gmail.com; David Sharples
Cc: oracle-l_at_freelists.org; 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mike Rothouse Sent: 01 June 2006 18:52
To: David Sharples
Cc: oracle-l_at_freelists.org; chris.grabowy_at_lmco.com 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_at_gmail.com> wrote:

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

On 01/06/06, Mike Rothouse <mrothouse_at_gmail.com > 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

--
http://www.freelists.org/webpage/oracle-l