Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 DBAReceived on Sun Apr 01 2007 - 09:11:46 CDT
![]() |
![]() |