RE: Cross-platform database move

Databee only deals with the ddl - not the data (at least the free version that I have only deals with DDL).

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dave Morley Sent: Tuesday, August 16, 2005 2:05 PM
To: fred_fred_1_at_hotmail.com; jkstill_at_gmail.com; Brandon.Allen_at_oneneck.com
Cc: oracle-l_at_freelists.org
Subject: Re: Cross-platform database move

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_at_hotmail.com> To: <jkstill_at_gmail.com>; <Brandon.Allen_at_oneneck.com> Cc: <oracle-l_at_freelists.org> 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_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
>
> _________________________________________________________________
> Don't just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l