Re: Cross-platform database move

Another option is to use materialized views.

Build the remote database as a logical duplicate of the database to be moved, then create mv's using the 'prebuilt table' clause.

There are some caveats: the tables must have a primary key.

If you can use this method, the downtime incurred from switching to the new environment is minimized.

This is of course dependent on the IO requirements of the system, whether your app and network can deal with the additional IO, etc.

Jared

On 8/16/05, Fred Smith <fred_fred_1_at_hotmail.com> wrote:
>
> 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/
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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