Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: index creation fails because temp tablespace is too small
On Thu, 5 May 2005 12:26:23 +0200, "Matthias Hoys"
<idmwarpzone_NOSPAM__at_yahoo.com> wrote:
>
>"karel" <karelje007_at_ftd.nl> wrote in message
>news:4270f9a6$0$24231$ba620dc5_at_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
>
It sure would. Also (at least in the past) indexes created on empty tables had always to be recreated immediately after import, because they were inefficient (data usually isn't loaded in the 'correct' order)
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu May 05 2005 - 05:40:53 CDT