Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!fr.ip.ndsoftware.net!skynet.be!newspost001!tjb!not-for-mail Reply-To: "Matthias Hoys" From: "Matthias Hoys" Newsgroups: comp.databases.oracle.server References: <426fa9d5$0$24221$ba620dc5@nova.planet.nl> <4270f9a6$0$24231$ba620dc5@nova.planet.nl> Subject: Re: index creation fails because temp tablespace is too small Date: Thu, 5 May 2005 12:26:23 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2527 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 Lines: 34 Message-ID: <4279f4d4$0$7749$ba620e4c@news.skynet.be> Organization: -= Belgacom Usenet Service =- NNTP-Posting-Host: f36b956a.news.skynet.be X-Trace: 1115288788 news.skynet.be 7749 81.244.126.83:1529 X-Complaints-To: usenet-abuse@skynet.be Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:242055 "karel" wrote in message news:4270f9a6$0$24231$ba620dc5@nova.planet.nl... > thanks all for your input. > > most of it i all ready knew. the question i've asked is about a > test database. In our production database we're gonna partition > the table in question. > > but for the fun of it I 'm now trying to use sqlldr with the > direct option > > steps i'm taking > 1 spool content off table to file > 2 truncate table > 3 enable all constraints including indexes > 4 disable all triggers on table > 5 load the data with sqlldr. > > i'll hope it works. > > thx all, > > karel > For performance reasons, wouldn't it be better to first load all the data into the table (step 5), and afterwards create the indexes and enable the constraints ? Matthias