Re: Ora 1652 during loading data via sql*loader even if i have enough space in Temp,data, and index tablespace

Sorry, I meant to add: if that isn't the problem, then it's fairly obvious that you *don't* have enough space in the index tablespace, and will need to do some tablespace resizing.

(SQL Loader does funny things with its index updates, and may well be creating a temporary structure in the 'wrong' tablespace so that it can merge its index updates with the proper index at a later time. Whilst you may think you've enough space for the finished index, it may well not be enough for the index+merge structures required for the load).

Regards
HJR "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:n6nm9.44169$g9.125885_at_newsfeeds.bigpond.com...
> Why is there a temporary segment in what is presumably your index
> tablespace?
>
> Do a select temporary_tablespace from dba_users where username=<name of
user
> doing the sql load>;
>
> If it turns up anything than the name of your proper temporary tablespace,
> do an
>
> alter user <same name as before> temporary tablespace TEMP;
>
> And then repeat the load.
>
> Regards
> HJR
>
> "nn" <nn_at_n.com> wrote in message
> news:anc9vf$ab8$1_at_s1.read.news.oleane.net...
> > Hi
> > I have this error when trying load data with sql*loader :
> > ORA-01652: unable to extend temp segment by 3200 in tablespace Tbs-Indx.
> >
> > i have enough space in Temp,data, and index tablespace.
> >
> > I can't drop index befor loading, what can i do? coalesce would resolve
> pb?
> >
> > Thank you
> > NN
> >
> >
>
>
Received on Tue Oct 01 2002 - 15:11:48 CDT