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. [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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>[EMAIL PROTECTED]</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>> RIK2.VARE.LEVNR,<BR>> RIK2.ART_HIERARKI_CALC.VGR,<BR>> RIK2.VARE.SORTIMENT,<BR>> RIK2.VARE.VARENAVN<BR>> FROM RIK2.VARE, RIK2.ART_HIERARKI_CALC<BR>> WHERE RIK2.VARE.SELSKAP='11' AND<BR>> RIK2.VARE.VARE_SNR=10<BR>> AND RIK2.VARE.VARENR=RIK2.ART_HIERARKI_CALC.VARENR<BR>> ORDER BY VGR<BR>><BR>><BR>> 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: [EMAIL PROTECTED]<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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).