Best way to move data beween servers

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 10 Mar 2003 10:35:00 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703675055@lnewton.leeds.lfs.co.uk>

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.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: QT [mailto:qtockar_at_hotmail.com]
Posted At: Monday, March 10, 2003 10:24 AM Posted To: server
Conversation: Best way to move data beween servers Subject: Best way to move data beween servers

Hi All

I need to move data from a Compaq Server to a Sun Server. The amount of data
is 0.5 terrabytes. This will be on Oracle 817. What is a good place to start
on how to do this and what would be the best way with the least downtime?

TIA QT Received on Mon Mar 10 2003 - 04:35:00 CST