Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "Anurag Varma" <avoracle@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Loading 300 million records
Date: 6 Jun 2005 14:06:46 -0700
Organization: http://groups.google.com
Lines: 20
Message-ID: <1118092006.577837.216690@g43g2000cwa.googlegroups.com>
References: <1118072447.344657.22030@g49g2000cwa.googlegroups.com>
   <1118080226.901207.197780@g44g2000cwa.googlegroups.com>
   <1118081679.953548.251960@g14g2000cwa.googlegroups.com>
   <1118090569.782968.240700@g49g2000cwa.googlegroups.com>
NNTP-Posting-Host: 13.8.125.11
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1118092011 28690 127.0.0.1 (6 Jun 2005 21:06:51 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 6 Jun 2005 21:06:51 +0000 (UTC)
In-Reply-To: <1118090569.782968.240700@g49g2000cwa.googlegroups.com>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=13.8.125.11;
   posting-account=Bjij0w0AAACWMZ9jVkCMjBKLT0Yf1PAH
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244377

Daniel,

Not knowing OP's overall process and considering that OP is doing a
insert /*+ append */ into maintable select ... from <join of 5 tables>;

... the idea of selecting from ext_tab and etl transforming does not
really compute.

Although, tuning his sql (maybe use parallel processing etc.) might
speed things up
for him.

The paper as such is ok. It does have some nice ideas about etl
processing
(especially the example you state above).

Cheers,

Anurag