Thanks for help
I have not space enough for the index+merge structures required for the
load. my ultime solution is to add space.
tx.
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> a écrit dans le message news:
ocnm9.44171$g9.125885_at_newsfeeds.bigpond.com...
> 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 Wed Oct 02 2002 - 03:26:32 CDT
