Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need advice, upgrading 7.3.4 to 10g
"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