Re: Performance issue while loading large amount of data

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sat, 11 Jan 2003 14:10:59 -0800
Message-ID: <3E209673.BA617BEA@exesolutions.com>

EP wrote:

> > Depends on the qualify of the data.
> >
> > What percentage of the rows are rejected do to constraint violations?
>
> I have no idea - it is not me who is preparing the scripts but I guess there
> will be many of them.
>
> Why does it matter ?
> In case of such problems only the erroneous statement is rolled back...
>
> Regards
> EP

If matters if you care about which rows are not loaded or do you not care about missing data?

If "I have no idea" is the best you've got I'd say you are in no position to make a decision about loading.

Assuming "many" and assuming that someone does care about knowing what was not loaded ... I would suggest using SQL*Loader.

Daniel Morgan Received on Sat Jan 11 2003 - 16:10:59 CST