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

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:05:23 CDT