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