Moving large databases

From: Jonathan Hunt <jonathan.hunt_at_vf.vodafone.co.uk>
Date: 1997/08/29
Message-ID: <3406F4F3.463074AE@vf.vodafone.co.uk>#1/1

Hi,

We are planning to move a 80GB database from Pyramid Nile (Oracle 7.2.3) to a Alpha server (Oracle 7.2.3 or Oracle 7.3). We need to reduce the down time to a mininum during the move. I would like to know about any material that may dicusss such moves (I know there was a paper written by Churchill Insurance UK for similar size database move, But where I can get a copy of that paper). I would also appreciate any hints/tips that helps in such a big exercise.

We have thought of the following options to speed up database move.

To do parallel (mutiple copies of exp) table exports and do parallel imports.
Copy tables/data using SQL* Plus copy command.

Give me your comments on the above or any other option that you may think of.

Thanking in anticipation.

Bala Avula
bala.avula_at_vf.vodafone.co.uk Received on Fri Aug 29 1997 - 00:00:00 CDT