Re: Dump from Linux/Oracle to AIX/Oracle
Date: Mon, 08 Sep 2008 16:04:25 +0200
On Mon, 8 Sep 2008 06:06:58 -0700 (PDT), marton.szabo_at_ivz.de wrote:
>i want to import data with oracle 10g/linux (machine a). then after
>importing the data into oracle i want to create a dump.
>it is possible to import this dump on oracle 10g/aix (machine b)? are
>there any problems or known difficulties between linux/oracle 10g and
>aix/oracle 10g concerning exporting/importing dumps?
>thanks in advance, marton
Provided with 'dump' you mean exports created by exp or expdp, there
are no issues.
Be aware though, expdp and impdp can work across databases and servers (so you don't need to expdp on one system, transfer, and impdp on the other), provided there is sqlnet connectivity between the two affected systems.
Also, if you decide not to follow this procedure, and choose to transfer your export by means of ftp, you need to transfer the file in *binary* mode.
Basically it boils down to reading the documentation, and obviously your question was trying to prevent that.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Sep 08 2008 - 09:04:25 CDT