see answer below
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> 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".
