Re: Oracle 7.3.2.3 import performance

Alan,

Try doing selects and then doing direct path SQL Loads. In my case it was much faster than running exports and imports.

Regards

Jerry  

> 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
> >
> >
> >
 

-- 
Jerry Gitomer		Since I know how to spell DBA I became one. 
jgitomer_at_p3.net