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
"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 Received on Thu May 05 2005 - 05:26:23 CDT