Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Moving a 250gig database from SUN to HPUX
We had to do something similar.
Look-up tables were moved using imp/exp.
Transaction tables where replicated using materialized views.
We froze the master site for a couple of hours overnight, refreshed the materialized views one last time, dropped the mlogs, dropped the materialized views, kept the underlying tables and switched the IP address in the ONAMES.
I'm leaving out the messy details about indexes, triggers, procs, userids, grants and privileges but for the data move the downtime was a few hours.
"Khedr, Waleed" <Waleed.Khedr To: <oracle-l_at_freelists.org> @FMR.COM> cc: Sent by: Subject: RE: Moving a 250gig database from SUN to HPUX oracle-l-bounce 05/25/2004 06:31 PM Please respond to oracle-l
What about copying tables' data over the network, using copy, or
insert/append/parallel dml?
Creating empty structure first without indexes (indexes could be rebuilt
at the end), loading the tables, and building the indexes.
Regards,
Waleed
-----Original Message-----
From: Guerra, Abraham J [mailto:AGUERRA_at_amfam.com]=20
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=3D"us-ascii"
Content-Transfer-Encoding: quoted-printable
Hello group,
=3D20
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.
=3D20
Any ideas or tools out there that would be a better approach?
=3D20
Your ideas/comments are appreciated.
=3D20
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
![]() |
![]() |