RE: Errormessage

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 19 Oct 2001 14:37:13 -0700
Message-ID: <F001.003B0891.20011019143527@fatcity.com>

see answer below

> -----Original Message-----
> From: Roland.Skoldblom_at_ica.se [mailto:Roland.Skoldblom_at_ica.se]
>
> what does this errormessage mean. I get  it when i try to do 
> this select statement.
> If I dont include the last two lines in the statement it
> works fine. What does this depend on? and which action shallI
> do to make it work?
>
> SELECT RIK2.VARE.EAN_NR,

>         RIK2.VARE.LEVNR,
>         RIK2.ART_HIERARKI_CALC.VGR,
>         RIK2.VARE.SORTIMENT,
>         RIK2.VARE.VARENAVN

> FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC
> WHERE RIK2.VARE.SELSKAP='11' AND

>        RIK2.VARE.VARE_SNR=10
>        AND RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR

> ORDER BY VGR
>
>
> ORA-03232: unable to allocate an extent of 62 blocks from tablespace 3

My personal guess would be that tablespace 3 is the temporary tablespace for the user issuing the query, and the "order by" is causing a sort that will use up space in your temporary tablespace. Removal of the "order by" eliminates the sort, which is why the statement is successful with removal of the "order by". Received on Fri Oct 19 2001 - 16:37:13 CDT