RE: Cross-platform database move

You can also export to a pipe, and then start up an import from that pipe to the other box off the same server. This also allows for multiple streams going at the same time.

Nice part is, there are no 20mb to 20gb files to move around.

Michael Kline
Database Administration
Outside 804.261.9446
Cell 804.744.1545
3-9446  

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Oded Maimon
> Sent: Tuesday, August 16, 2005 5:58 PM
> To: fred_fred_1_at_hotmail.com
> Cc: oracle-l_at_freelists.org
> Subject: Re: Cross-platform database move
>
> exp/imp, just disable the archives when importing.
> you can also split the exports to schemas and import parallel.
> import all indexes and constraints at the end
>
>
> Fred Smith wrote:
>
> > Hello,
> > I am attempting to make a copy of a production database that is on
> > HP-UX and put it on a Solaris 5.8 box for testing.
> > What are my choices for copying from one platform to the other? Just
> > exp/imp? Both databases are 9.2.0.x. I'm dealing with roughly 90Gig.
> >
> > tia,
> > -Fred S.
> >
> > _________________________________________________________________
> > 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
        

LEGAL DISCLAIMER
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.   

Seeing Beyond Money is a service mark of SunTrust Banks, Inc. [ST:XCL]        

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