Re: SQL*Loader on steroids

On 1 Apr 2007 00:16:49 -0700, "dombrooks" <dombrooks_at_hotmail.com> wrote:

>Direct path should realise some significant gains, however there are
>certain restrictions.
>
>It might be that you'd have to re-arrange processing a little, so that
>you use direct path to load up into staging tables as quickly as
>possible and the do the processing / data cleansing using bulk
>operations.

Excellent remark. It is also very important to avoid checks in a loop. It is better to
update foo
set status = 'E'
where <somecheck>

and finally issue
insert into production_table
select * from foo

-- 

Sybrand Bakker
Senior Oracle DBA