Other Oracle database topics - Regarding Sql-Loader

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Regarding Sql-Loader

pankaj_wolfhunter@yahoo.co.in

2006-02-28, 8:25 pm

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

Sponsored Links