| copy database between platforms [message #73550] |
Thu, 20 May 2004 01:23  |
cameron
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
I have a 450GB database on a LINUX Platform. I need to copy this database onto a UNIX platform at a remote site. Thus tapes shall be used to transfer the data.
The filesystem structure on the UNIX platform will differ from the LINUX platform, therefore directory path names shall differ from the LINUX machine.
What is the best way to copy this database. Any help shall be greatly appreciated
|
|
|
|
| Re: copy database between platforms [message #73551 is a reply to message #73550] |
Thu, 20 May 2004 04:55  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
You will have to export the LINUX database to tape, create a new database on your UNIX platform, and import the data. Direct backup and restore will not work as the platforms might use different encodings, word sizes and endian types.
BTW: If your LINUX DB is on Oracle 10g, you could just transport the tablespaces from your LINUX platform to the UNIX platform.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
