Re: Oracle 7.3.2.3 import performance

From: Pei L. Ku <pku_at_gte.net>
Date: 1998/03/08
Message-ID: <6dt04o$p0c$3@gte2.gte.net>#1/1

If possible, perform import without any any indexes (including PKeys). If you are doing that already, try parallellize import by running simultaneous imports, each importing a different set of tables...

Pei

Alan Downing <aldowning_at_email.msn.com> wrote in article <OvKhY1MS9GA.335_at_upnetnews02.moswest.msn.net>...
> I need to improve the time it takes to import data from 7.1.6 to 7.3.2.3
> Oracle on a Dynix/ptx platform. At present it is taking about 26 hours.
The
> job must be done using tape as there is a space restriction on the
servers
> disks. We have tried adjusting one or two of the parameter file settings
but
> are now running out of time for experimentation as our new application,
> which only runs on 7.3.2.3, must be up and running by the 16th March.
>
> Can anyone help please?
>
> Alan
>
>
>
Received on Sun Mar 08 1998 - 00:00:00 CST