Re: help!!! data migration

Use the compression thru pipes method to do an export of the database. FTP the resulting file(s) to the other server. Make sure you do the FTP in binary mode. Then import it thru a pipe to uncompress it on the way into the database. (This gets around the 2 gig limit on exports.)

Look for the files by Rachel Carmichael on the LazyDBA website for a great method for doing compressed exports and imports.

I have heard that if you are using the right version of Oracle the export will automatically be broken up into 2 gig chunks but I am not there.

HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, March 27, 2001 1:05 AM

> hi ppl,
>
> i want to migrate oracle database from solaris to NT and vise versa..
> can anybody tell me the best way to do it. my database sixe is around
25GB.
>
>
> thanks
>
>
> - NIHAR SANGHVI
>
> NetMagic Solutions Pvt. Ltd.
> 22,Nirlon Complex,Western Express Highway,
> Goregaon (E), Mumabai 400 063
>
> Phone: 8723003 extn: 144
> www.netmagicsolutions.com
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nihar
> INET: nihar_at_netmagicsolutions.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).