Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to move data beween servers

Re: Best way to move data beween servers

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 11 Mar 2003 05:29:57 +1100
Message-Id: <pan.2003.03.10.18.29.55.962670@yahoo.com.au>


On Mon, 10 Mar 2003 09:28:56 +0000, Pete Sharman wrote:

> In article <pan.2003.03.10.17.17.20.472759_at_yahoo.com.au>, "Howard says...

>>
>>On Mon, 10 Mar 2003 10:35:00 +0000, Norman Dunbar wrote:
>>
>>> Morning QT,
>>>
>>> if you are wanting to move Oracle data between two different
>>> servers/operating systems, then you will have to go via exp/imp (unless
>>> RMAN allows you to do it) because of the differing OS features like
>>> big-endian/little endian etc. If you try to do a database clone, then
>>> when you try to startup you'll get a telling off from Oracle and it
>>> won't start.
>>>
>>> I'm not at all familiar with transportable tablespaces, but I suspect
>>> that they won't transport very well between OS - I'll be corrected on
>>> this if I'm worng, but I've never had (to have) anything to do with them
>>> since I did my 9i upgrade course.
>>>
>>> HTH
>>>
>>> Regards,
>>> Norman.
>>
>>Officially, transportable tablespaces require the same O/S and the same
>>point-and-patch release of Oracle. Whether Tru64 and Solaris count as the
>>same OS (ie "Unix"), I couldn't say. But I seriously doubt it.
>
> Mg Gawd, something I know that Howard isn't sure about!!! :)

There are plenty of other examples, Pete.

Just not many involving Oracle!!

Regards
HJR Received on Mon Mar 10 2003 - 12:29:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US