| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving a 250gig database from SUN to HPUX
Abraham,
If you can wait, upgrade to 10g and then move databases across = platforms. I do not know what your project dead lines are.... If you are below 10g, export and import is the only way you can move = across platforms. We wanted to move from Sun to AIX and backed off due = to the downtime involved in export and import.
Chaya
Sr. Database Administrator=20
--"The opinions expressed herein are solely the author's and are not =
necessarily the opinion of USAA."=A0--=A0=A0=A0=A0=A0=A0=A0=A0=A0=20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Goulet, Dick
Sent: Tuesday, May 25, 2004 3:18 PM
To: oracle-l_at_freelists.org
Subject: RE: Moving a 250gig database from SUN to HPUX
Abraham,
Try multiple exp/imp sessions based on owner. For large tables I'd =3D
probably export the structure to a sql script and then use copy to move =
=3D
the data. Building indexes afterwards.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Guerra, Abraham J [mailto:AGUERRA_at_amfam.com]
Sent: Tuesday, May 25, 2004 4: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=3D3D"us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello group,
=3D3D20
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.
=3D3D20
Any ideas or tools out there that would be a better approach?
=3D3D20
Your ideas/comments are appreciated.
=3D3D20
Abraham Guerra
American Family Insurance
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |