| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cross-platform database move
Yes, you can exp from HP-UX and imp into Sun. Exp produces an OS
agnostic file. One caveat, you want to be on the same version or from
an earlier to later version.
Jim
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fred Smith
Sent: Tuesday, August 16, 2005 10:50 AM
To: jkstill_at_gmail.com; Brandon.Allen_at_oneneck.com
Cc: oracle-l_at_freelists.org
Subject: Re: Cross-platform database move
Unfortunately there are rougly 1000 tables (in multiple schemas).
Do you know if I can use exp from HP-UX and imp from Sun? (or must I do both using the same OS)?
Thanks.
>From: Jared Still <jkstill_at_gmail.com>
>Reply-To: jkstill_at_gmail.com
>To: Brandon.Allen_at_oneneck.com
>CC: fred_fred_1_at_hotmail.com, oracle-l_at_freelists.org
>Subject: Re: Cross-platform database move
>Date: Tue, 16 Aug 2005 10:39:15 -0700
>
>On 8/16/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> >
> > I believe exp/imp is your only option for 9.2, but if you upgrade
> > both
>to
> > 10g, and then you can use cross-platform transportable tablespaces.
> >
> >
>Dependent on the table structure, you could also use a utility to dump
>to flat files and load with sql loader.
>
>The advantage is the speed of sqlldr over imp.
>
>Whether exp/imp or sqlldr, you should be able to dump the data to a
>socket and read it simultaneously on the target system, with no need to
>create permanent files. (This is one thing you cannot do on Win32)
>
>--
>Jared Still
>Certifiable Oracle DBA and Part Time Perl Evangelist
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 16 2005 - 12:59:57 CDT
 |
 |