Re: Errormessage

Hi Roland, check if your temp tablespace is getting filled up (look at dba_free_space, v$sort_segment, v$sort_usage). Are you getting any other messages with this one ?

Mandar.

ORACLE-L_at_fatcity.com wrote:

Hallo

I run this select statement and get this errormessage. What should I do to solve it? I have a databaselink from the actual schema to another schema.

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

Thanks in advance

Roland

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
INET: Roland.Skoldblom_at_ica.se

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Get Your Private, Free E-mail from Indiatimes at  http://email.indiatimes.com
Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from 
http://www.planetm.co.in

--=_MAILER_ATTACH_BOUNDARY1_2001102321319121061730690
Content-Type: text/html; charset=us-ascii

<P>Hi Roland, check if your temp tablespace is getting filled up (look at 
dba_free_space, v$sort_segment, v$sort_usage). Are you getting any other messages with 
this one ?</P>
<P>Mandar.</P>
<P><BR><BR><B><I>ORACLE-L_at_fatcity.com</B></I> wrote:<BR><BR></P>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 
5px"><BR>Hallo<BR><BR><BR><BR><BR><BR>I run this select statement and get this 
errormessage. What should I do to solve it? I have a databaselink from the actual 
schema to another schema.<BR><BR><BR><BR><BR><BR>SELECT RIK2.VARE.EAN_NR,<BR>&gt; 
RIK2.VARE.LEVNR,<BR>&gt; RIK2.ART_HIERARKI_CALC.VGR,<BR>&gt; 
RIK2.VARE.SORTIMENT,<BR>&gt; RIK2.VARE.VARENAVN<BR>&gt; FROM RIK2.VARE, 
RIK2.ART_HIERARKI_CALC<BR>&gt; WHERE RIK2.VARE.SELSKAP='11' AND<BR>&gt; 
RIK2.VARE.VARE_SNR=10<BR>&gt; AND 
RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR<BR>&gt; ORDER BY 
VGR<BR>&gt;<BR>&gt;<BR>&gt; ORA-03232: unable to allocate an extent of 62 blocks from 
tablespace 3<BR><BR><BR>Thanks in advance<BR><BR><BR><BR><BR><BR>Roland<BR><BR>-- 
<BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>-- <BR>Author: 
<BR>INET: Roland.Skoldblom_at_ica.se<BR><BR>Fat City Network Services -- (858) 538-5051 
FAX: (858) 538-5051<BR>San !
!
!
Diego, California -- Public Internet access / Mailing 
Lists<BR>--------------------------------------------------------------------<BR>To 
REMOVE yourself from this mailing list, send an E-Mail message<BR>to: 
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, 
include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to 
be removed from). You may<BR>also send the HELP command for other information (like 
subscribing).</BLOCKQUOTE><BR>
<hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at  
</font><a href="http://email.indiatimes.com"><font face="Arial" 
size="2">http://email.indiatimes.com</font></a></b><br>Buy Music, Video, CD-ROM, 
Audio-Books and Music Accessories from <A 
href="http://www.planetm.co.in">http://www.planetm.co.in</A>

--=_MAILER_ATTACH_BOUNDARY1_2001102321319121061730690--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Shete
  INET: mandar_shete_at_indiatimes.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).