Re: Regarding Sql-Loader
- From: DA Morgan <damorgan@xxxxxxxxx>
- Date: Tue, 28 Feb 2006 09:47:19 -0800
pankaj_wolfhunter@xxxxxxxxxxx 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@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.
- References:
- Regarding Sql-Loader
- From: pankaj_wolfhunter
- Regarding Sql-Loader
- Prev by Date: Re: Find Duplicate Values with Varying Start Dates
- Next by Date: Re: Q: why are these logons different?
- Previous by thread: Regarding Sql-Loader
- Next by thread: Regarding Sql-Loader
- Index(es):
Relevant Pages
|
|
