RE: Cross-platform database move
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: <fred_fred_1@xxxxxxxxxxx>
- Date: Tue, 16 Aug 2005 13:59:32 -0400
Fred,
You can use exp/imp from both platforms. The export file is platform
independent.
If you ftp the file over, be sure and use binary mode.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fred Smith
Sent: Tuesday, August 16, 2005 1:50 PM
To: jkstill@xxxxxxxxx; Brandon.Allen@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx>
>Reply-To: jkstill@xxxxxxxxx
>To: Brandon.Allen@xxxxxxxxxxx
>CC: fred_fred_1@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
>Subject: Re: Cross-platform database move
>Date: Tue, 16 Aug 2005 10:39:15 -0700
>
>On 8/16/05, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> 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
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: