Oracle heterogeneous system copy

[Fred Morin_1]

We have a Oracle 8.1.7 database on a Reliant UNIX server in Europe, we want to transfer this database on a HPUX RP2470 11i in Canada.
Other than a export, what is the best way to do that?

[Steven E. Protter]

Assuming the versions of the database are the same, you can clone the database.

Shut it down.

Copy all the tablespaces to the new system.

Follow the attached 32 bit to 64 bit word size conversion documentation.

SEP

[Fred Morin_1]

You means copy all datafiles, in the same stucture?

[Jean-Luc Oudart]

Hi,

I don't think you can copy datafiles accross different platforms.

I suppose you have access to Metalink.
check doc id 270555.996

there are lot more around cross platform migration.


Rgds,
Jean-Luc

[Volker Borowski]

Hi,

not really much else I guess.
If it is not that big, you could try to link source and target over the net an try some sort of replication (ssh-tunnel for sql-net connection of course to be encrypted).

Watch CHARSET problems if the source-DB is an old one.

Hope this helps
Volker

[Graham Cameron_1]

Your source Reliant unix box is a different architecture to the destination HP, and you would be very lucky if oracle database files were portable between the two.

Export/Import is your only supported option.

You could compress the export file before you ship it to reduce your transatlantic network load.

If you don't have the disk space to hold the export file you could use a named pipe. There is a thread at
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x02cb506d69a7d711abdc0090277a778c,00.html
although this would have to be extended to handle cross-machine transfer.

You could also split your export file into smaller chunks, and ship them over one at a time, using the FILESIZE export option.

-- Graham