RE: Moving a 250gig database from SUN to HPUX

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 26 May 2004 07:52:06 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B006CC@EXCHMN3>

Abraham

I recently performed the same task, moving a 150-gig database from Alpha to Sun. I received some excellent suggestions from the people on this list. I was not brave enough to consider the direct file methods that has been suggested on this thread. Overall, 3 major methods were suggested:

Export/import
SQL*Net COPY
Write to a flat file, SQL*Loader Many people spoke favorably of the SQL*Loader method. It should scale out well, supporting several parallel processes. The limitation is a high-performance method for creating the flat file. In my case it turned out that the new server was a real screamer. It could import faster than the old server could export. The entire export/import/index build cycle took only about 8 hours. You have received some excellent suggestions. Best of luck on your project.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Guerra, Abraham J Sent: Tuesday, May 25, 2004 3:03 PM
To: ORACLE-L_at_freelists.org
Cc: Morrissey, Jay A
Subject: Moving a 250gig database from SUN to HPUX

Content-Type: text/plain;

charset="us-ascii"
Content-Transfer-Encoding: quoted-printable Hello group,
=20

Has any of you moved a 250+ database from SUN into HPUX? I have a window of 36 hours to do this. I'm planning to divide the database into multiple imports/exports and multi-tasks them.
=20

Any ideas or tools out there that would be a better approach?
=20

Your ideas/comments are appreciated.
=20

Abraham Guerra
American Family Insurance

Binary/unsupported file stripped by Ecartis --
Type: image/jpeg
File: Notebook.jpg
Desc: Notebook.jpg

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed May 26 2004 - 07:51:50 CDT