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 -> Ora 1652 during loading data via sql*loader even if i have enough space in Temp,data, and index tablespace

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

From: nn <nn_at_n.com>
Date: Tue, 1 Oct 2002 16:02:32 +0200
Message-ID: <anc9vf$ab8$1@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 - 09:02:32 CDT












Original text of this message













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