Re: Cross-platform database move
- From: "Dave Morley" <dmorley@xxxxxxxxxxxxxxxxxxx>
- To: <fred_fred_1@xxxxxxxxxxx>, <jkstill@xxxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>
- Date: Tue, 16 Aug 2005 14:05:16 -0400
Fred,
You should check out the databee database tool. It is available from
www.databee.com and provides a lot of flexibility. It allows you to set up
rules and make mini databases from full production that actually work. You
can also set up rules that allow you to copy one database to another on
different machines.
Dave
----- Original Message -----
From: "Fred Smith" <fred_fred_1@xxxxxxxxxxx>
To: <jkstill@xxxxxxxxx>; <Brandon.Allen@xxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, August 16, 2005 1:50 PM
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:
