Re: Import into a database takes a long time

From: Reid Lai <reidlai_at_hk.super.net>
Date: Sat, 28 Nov 1998 00:39:17 +0800
Message-ID: <365ED5B4.632AC5A3@hk.super.net>

And should turn on direct path loading.

Diego Pafumi wrote:

> Hi !!!
> First try to delete all the indexes, then you can recreate it.
> Then when you are making the import, commit each row, so it will go faster.
>
> Good luck !!!
> Diego
>
> MTaylo1987 wrote:
>
> > I am trying to do an import of data into a database using the standard import
> > facility but it seems to take forever. What areas should I look at for possible
> > performance gains.
> >
> > Ta
> >
> > Mike

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Oracle 7.3 Certified Database Administrator (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Nov 27 1998 - 10:39:17 CST