Re: index creation fails because temp tablespace is too small

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 Received on Thu Apr 28 2005 - 09:56:38 CDT