pankaj_wolfhunter_at_yahoo.co.in wrote:
> Greetings,
> I have a requirement of loading millions of data Using
> Sql_loader. Here I have given a script that tells the current process
> of loading data into Oracle tables. The data is appended into the
> respective tables in Oracle. After that all the indexes are rebuild and
> so it goes on.
> Just wanted to ask, is it possible to build the indexes in parallel to
> sql loader. I mean can I create some jobs that can do this job? Does
> this helps in performance?
>
> I am using Oracle Database 10g Enterprise Edition Release 10.1.0.3.0
>
> Any help would be appreciated.
>
> TIA
What is the difference between building indexes in parallel and not
wasting time dropping them in the first place? Millions of records
is not a lot.
But take a look at direct path loads. DIRECT=TRUE.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Feb 28 2006 - 11:47:19 CST
