Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: index creation fails because temp tablespace is too small

Re: index creation fails because temp tablespace is too small

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 05 May 2005 12:40:53 +0200
Message-ID: <hutj71l8ov85ssqdhs63hajri660vdbikj@4ax.com>


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 DBA
Received on Thu May 05 2005 - 05:40:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US