Re: need advice, upgrading 7.3.4 to 10g

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 13 Sep 2005 21:24:47 +0200
Message-ID: <4327277f$0$10958$ba620e4c@news.skynet.be>

"JSchneider" <jeremypaulschneider_at_gmail.com> wrote in message news:1126636549.422059.187810_at_g49g2000cwa.googlegroups.com...
>
> EdStevens wrote:
>> Paul wrote:
>> > Regardless of architecture, can one just copy datafiles from one
>> > system to another? Windows -> Linux or whatever?
>>
>> Absolutely not. And not 'regardless of architecture' but *specifically
>> because of* architecture.
>
> The transportable tablespace feature would allow you to directly copy
> datafiles between platforms with the same endian-ness. That's what I
> meant to refer to; however in this case you would need to upgrade the
> source platform first and then use RMAN to convert the datafiles before
> copying them... and it's debatable what advantage this has over just
> using export/import.
>

The advantage of imp/exp is also that all your tables and indexes get nicely rebuild (into LMT's) so goodbye to any existing tablespace fragmentation.

Matthias Received on Tue Sep 13 2005 - 14:24:47 CDT